Skip to Main Content

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!

XPath Expression Problem

654864Aug 21 2008 — edited Aug 22 2008
Hi again,

still a newb and stillsomequestions, but hope dies at last :)
I want to extract values from a xml file which is stored in a table.

i have the following code:

COLUMN div DEFAULT

SELECT extract(value(x), '//DIV/@ ID = ''FXAC93006ENC.0001.01.00''/text()').getStringVal() AS div
FROM versuch2 x;

With this code ive got the following Error Message: ORA:31012: Not supported XPath Statement.

I tried this XPath statement in SlyXML and got a boolean:true result, so i think its not a xpath problem.
Isthere a syntax problem?

Thx for help!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 19 2008
Added on Aug 21 2008
7 comments
1,041 views