Getting Error while trying to use GETXML API in plsql

From: Arvind Kapil <kapil_arvind_at_yahoo.com>
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

Original text of this message