Getting Error while trying to use GETXML API in plsql
Date: 22 Aug 2001 12:26:29 -0700
Message-ID: <35e7e8ef.0108221126.43f0cd21_at_posting.google.com>
When i try to run the underwritten code it is giving me following
error.
I am using JServer Release 8.1.7.2.0 - Production
SQL> declare
2 queryCtx DBMS_XMLquery.ctxType;
3 result CLOB;
4 begin
5
5 -- set up the query context...!
6 queryCtx := DBMS_XMLQuery.newContext('select * from emp');
7
7 -- get the result..!
8 result := DBMS_XMLQuery.getXML(queryCtx);
9 -- Now you can use the result to put it in tables/send as
messages..
10 printClobOut(result);
11 DBMS_XMLQuery.closeContext(queryCtx); -- you must close the
query handle..
12 end;
13 /
declare
*
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
java.lang.NullPointerException
ORA-06512: at "SYS.DBMS_XMLQUERY", line 206 ORA-06512: at "SYS.DBMS_XMLQUERY", line 214 ORA-06512: at "SYS.DBMS_XMLQUERY", line 204 ORA-06512: at line 8
Can anyone help me getting out of it.
Thanks in advance.
Received on Wed Aug 22 2001 - 21:26:29 CEST