Problem with dollar sign and PL/SQL and XPath
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!