trouble xmlsequence ORA-22905
641120Jun 3 2008 — edited Jun 3 2008Hello i'm working with oracle 9.2.6.0 and i'm using xmlsequence to insert values in a table.
insert into TM_MSVAR (MSG_NTAG , MSG_VTAG )
select XMLTYPE (EXTRACT (VALUE (t), '/').getstringval ()).getrootelement(),
EXTRACTVALUE (VALUE (t), '/')
FROM TABLE(XMLSEQUENCE(EXTRACT(XML_MESA , '/*'))) t
when i try it i get the error ORA-22905: cannot access rows from a non-nested table item
i search about this and i found that is a bug of oracle, that i can solve if i put the text of my xml variable in the from...but i dont know the text..
is ther another way to solve this???
please help me!!!!!!
Rose