Can PL/SQL read in XML files?

[wellster34]

Hello,

I was curious if PL/SQL can read in XML files and process the information. The version of Oracle is 8.1.7.4

If not, is there a work-around?

Thanks for you time

 

[SantaMufasa]

Wellster,

Sorry that I'm not an Oracle/XML aficionado, but I'd bet several quid on the notion that PL/SQL can process XML just fine. I see some pretty good-looking hits on Google when I search for "PL/SQL XML Oracle 8.1.7.4".

Let us know your findings,

Mufasa
(aka Dave of Sandy, Utah, USA @ 18:49 (02Sep04) UTC (aka "GMT" and "Zulu"), 11:49 (02Sep04) Mountain Time)

 

[HimanB]

Hi,
Yes this is very much possible.
In order to achive this you need to make use of DBDOM package.
Please refer to Thread759-821859

HTH
Regards
Himanshu

 

[carp]

I would recommend you get a copy of "Building Oracle XML Applications" (by Steve Muench, published by O'Reilly press). It covers how to work with XML in both PL/SQL and Java.