extracting data from xml file

[zulu99]

Hi All


In my current application , application A sends me data (clob)
via AQ over dblink .
The content of the clob column with be xml.

I need to extract each node element value in the xml and
build an insert query.

My application would have run fine had we got a 9i db with facilities
like xml datatype, methods like extractvalue etc.

But we have a 8.1.7 db.
I need to extract values at different nodes of the xml file.

How do i go about it.

Regards

[TimHall]

Hi.

Here's an example of what you need to do:

http://www.oracle-base.com/Articles/...ocuments8i.asp

Cheers