DevOps, CI/CD and Automation

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 Error - ORA-31013

alpicusSep 2 2008

Hi,

I tried the following SQL statement in Oracle 9.2 :

SELECT mytable.myfield.extract('/E0/E02/*[ E23 = "C300"][E22 = max(//E22)][1]/E29/E31/text()') AS "myalias"
FROM mytable

but I receive the following error : ORA-31013: Invalid XPATH expression

It seems that max is not supported. Is it possible ? Is there a workaround ?

The XML data from myfield is here : http://www.experts-exchange.com/Database/Oracle/9.x/Q_23688573.html

TIA,

Phil

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 30 2008

Added on Sep 2 2008

#general-xml, #xml

0 comments

1,140 views