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!

ORA-29532 due to ORA-00936: missing expression

68773Mar 19 2003 — edited Mar 19 2003

I have a PL/SQL packaged procedure that is using DBMS_XMLQuery.getXML to generate XML. It works fine when called directly, such as from SQL*Plus. But when called from an Oracle job (DBMS_JOB), I get the following error in the alert.log:

Errors in file <trace file>:
ORA-12012: error on auto execute of job 303
ORA-29532: Java call terminated by uncaught Java exception: oracle.jdbc.driver.O
racleSQLException: ORA-00936: missing expression
ORA-06512: at "SYS.DBMS_XMLQUERY", line 256
ORA-06512: at "SYS.DBMS_XMLQUERY", line 264
ORA-06512: at "SYS.DBMS_XMLQUERY", line 254
...

Has anyone encountered this before? Any solutions or workarounds?

Oracle 8.1.7.4
XDK 9.2.0.4.0

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 16 2003

Added on Mar 19 2003

#general-xml, #xml

1 comment

341 views