ORA - 29532 using XML
Date: 19 Jul 2002 11:34:03 -0700
Message-ID: <9bdf2bd2.0207191034.2189fd1b_at_posting.google.com>
Hi,
We get an ORA-29532 when executing what is a relatively simple query - please see code below. Does anyone have any ideas? We are running Oracle 8.1.7.3 on an HP 9000/820 under HP-UX B.11.00.
Any help greatly appreciated!
declare
queryCtx DBMS_XMLquery.ctxType;
result clob;
begin
DBMS_JAVA.SET_OUTPUT (1000000);
queryCtx := DBMS_XMLQuery.newContext('select 1 from dual');
result := DBMS_XMLQuery.getXML(queryCtx);
DBMS_XMLQuery.closeContext(queryCtx);
exception when others then
dbms_output.put_line(substr(sqlerrm,1,255));
end;
EXCEPTION
java.lang.NullPointerException
at oracle.xml.sql.query.OracleXMLStaticQuery.getXML(OracleXMLStaticQuery.java:628)
ORA-29532: Java call terminated by uncaught Java exception:
java.lang.NullPointerException
Received on Fri Jul 19 2002 - 20:34:03 CEST