Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2010
    Posts
    1

    Unanswered: ORA-22806: not an objetct or REF. HELP please

    hello, help whit problem please
    table1
    id
    1
    .
    table2
    id id_table1 person_id d1 d2
    1 1 1000 0 3
    2 1 2000 1 5
    3 1 3000 8 9
    and convert to row in colum whit this query

    SELECT table2,
    substr(emd,0,instr(emd,' ',1,1)) chain1,
    substr(emd,instr(emd,' ',1,1) +1 ,instr(emd,' ',1,2) - instr(emd,' ',1,1)) chain2,
    substr(emd,instr(emd,' ',1,2) +1 ,instr(emd,' ',1,3) - instr(emd,' ',1,2)) chain3
    FROM (SELECT
    table2.id,
    rtrim (xmlagg (xmlelement (e, person_id ||' '|| d1 ||' '||d2 ||' ')).extract ('//text()'), ',') emd
    FROM
    Tabl2
    group by
    table2.id) inner join
    table1 se on (table2 = table1.id)

    result:
    Result :
    id person_id d1 d2 person_id d1 d2 person_id d1 d2
    1 1000 0 3 2000 1 5 3000 8 9


    work in oracle 10g express edition...
    no work in oracle 9i-> ORA-22806: not an objetct or REF.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >work in oracle 10g express edition...
    >no work in oracle 9i-> ORA-22806: not an objetct or REF.

    Not all features, functions, or datatypes exist in all versions
    Both V9 & V10 are no longer supported.
    If you upgraded to supported version no problem would exist.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •