Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-31013: Invalid XPATH expression

497395Jul 22 2006 — edited Apr 28 2009
Hi,
I am getting this error when i am trying to execute a sp which will do xml parsing.
What all i did is i have Oracle database with 9.2.0.1.0 version. The i hav ugraded the database to 9.2.0.6.0 using the Oracle patch. After upgrading the Oracle db to 9.2.0.6.0 i got the below error:
ORA-00600: internal error code,
Then i ran the catpatch.sql to get rid off this error. After running the catpatch.sql the above error gone but i got another error
ORA-31013: Invalid XPATH expression.
What does this mean. The sp is working fine before upgrading the Oracle db to 9.2.0.6.0. Is the patch upgrade corrupted any of the XML libraries or the 9.2.0.6.0 doesn't support the xml parsing or do i need to apply any patch for this.
Please suggest me ASAP since this error has been raised at cusotmer and i am in very much need of this.
The statement which i am using for parsing the xml file is
x.xml_data.extract('/x:recording/@x:ref').getStringVal() from xml_process;
where xml_process is a table of xml_type.

Thanks
Rao

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 26 2009
Added on Jul 22 2006
#performance-availability, #xml-db
13 comments
22,024 views