Database Software

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!

How to use PL/SQL to read and manipulate data from a xml file

487416Feb 1 2006 — edited Feb 6 2006

Hi,

I have a XML file and i need to read data on the file to manipulate it and then insert in a oracle table (not with xmlType attributes). I just need to be able to access xml nodes in the file and manipulate data of the nodes. The thing is that i need to do this with a pl/sql procedure compiled in the Database, version 9.2.07.

Can someone give a good orientation on how to do this? I'm totally lost here and have lot of urgency.

I've seen examples of reading the xml file with BFILE, but i do not have sysDBA permissions on the database and failed to do it.

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 6 2006

Added on Feb 1 2006

#performance-availability, #xml-db

10 comments

6,957 views