SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Upadting a XML node value to another table

DepakjanOct 21 2010 — edited Oct 21 2010

Hi guys,

Can you please tell me, what is wrong with the below query

 update csabcd cs set (cs.ELEMENT,cs.ELEMENT2,cs.ELEMENT3) =
        (select x.* from abcde a, xmltable ('.' passing XMLTYPE(a.xml)
             columns mort1 varchar2 (80) path '/alert/tab1/details/Element',
                     mort2 varchar2 (80) path '/alert/tab1/details/Element2',
                     mort3 varchar2 (80) path '/alert/tab1/details/Element3'
                     ) x  where cs.aid = a.aid);

i get this error

ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00229: input source is empty
Error at line 0
ORA-06512: at "SYS.XMLTYPE", line 254
ORA-06512: at line 1

Edited by: Depakjan on Oct 21, 2010 1:35 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 18 2010

Added on Oct 21 2010

7 comments

781 views