Database Software

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!

position() function in XPATH

MichaelSApr 19 2007 — edited Apr 23 2007

Hello,

does anyone know how to get the position() function to work in a XPATH Queries? What I tried until now is

SQL>  SELECT EXTRACTVALUE (COLUMN_VALUE, '/row/a/position()') p
  FROM TABLE (XMLSEQUENCE (XMLTYPE ('<row><a></a><a></a></row>')))
*
Error at line 0
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00601: Invalid token in: '/row/a/position()'

The XPATH expression should be fine as it is tested in Stylus Studio.
Any clues?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 21 2007

Added on Apr 19 2007

#performance-availability, #xml-db

7 comments

13,217 views