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.