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!

Insert child node using xml db in pl/sql (oracle 9i)

Dibyendu ChakrabortyJun 2 2008 — edited Jun 3 2008

An xml document will be passed as an input parameter to the procedure. I will have to get the node values and need to insert/update those into relational tables. Those things I did using extract, extractValue, XMLSequence. Now I need to do one more thing. I need to insert child nodes with the xml. Functions insertChildXML, appendChildXML etc are available with oracle 10g. But I have to do those things using oracle 9i. Could you please tell me how to do that?
I need these urgently.
thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 1 2008

Added on Jun 2 2008

14 comments

757 views