Skip to Main Content
Forums

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!

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.

Problem with dollar sign and PL/SQL and XPath

armsargis-JavaNetApr 28 2008 — edited May 6 2008
I have following query

..........................
newManifest := xmldata.transform(DBURIType('/OPS$ASY/STYLESHEET_TAB/ROW[ID=1]/STYLESHEET/text()').getXML());
dbms_output.put_line(newManifest.getClobVal());


and got following:

ORA-31013: Invalid XPATH expression
ORA-06512: at "SYS.DBURITYPE", line 4
ORA-06512: at "SYS.DBURITYPE", line 40
ORA-06512: at "OPS$ASY.GENERATE_MANIFEST", line 21
ORA-06512: at line 12

I understand that problem in '$' sign but I could not find the way to escape it :-(, please help!

Comments

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

Post Details

Locked on Jun 3 2008
Added on Apr 28 2008
#general-xml, #xml
5 comments
5,523 views