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!

inserting to a table from XML file loaded in a BLOB column

RameshkumarTFeb 3 2011 — edited Feb 4 2011

I have a table bill (billid number(10), billdetail blob) .I am loading a XML file into this table .My requirement is to read the XML file and write the values into a table .
Can someone help me with a sample code .
I am trying to use DBMS_BLOB.READ and xmlgen.insertXML to do the same.
Since I am new to SQL/PLSQL I am having difficulties writing a code.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 4 2011

Added on Feb 3 2011

#xml

9 comments

680 views