XMLQuery returning Java Exception

Hi all,
I'm a new Oracle DBA and have just undergone my first Oracle upgrade (10.2.0.1). My programmer has shown me an error from XMLQuery returning a Java error ORA - 29532. Below is the XML code and the Java Error. Can anyone please tell me where I went wrong?

I have checked permissions on the Oracel Server for the Procedure, Schema, and the user. All are the same as the old server (which ran 10.1.0.2). The same code works fine in the old.

• XML code --------------- create or replace procedure getXMLData(sqlstring IN clob,toplevelname IN varchar2,xmlout OUT clob) is queryCtx DBMS_XMLquery.ctxType; begin queryCtx := DBMS_XMLQuery.newContext(sqlstring); DBMS_XMLQuery.propagateOriginalException(queryCtx,true); DBMS_XMLQuery.setRowTag(queryCtx,'row'); -- sets the row tag name DBMS_XMLQuery.setRowSetTag(queryCtx,toplevelname); -- sets rowset tag name DBMS_XMLQuery.UseNullAttributeIndicator(queryCtx,true); DBMS_XMLQuery.SetTagCase(queryCtx,1); xmlout := DBMS_XMLQuery.getXML(queryCtx); DBMS_XMLQuery.closeContext(queryCtx); end getXMLData;

  ---

  Java Error: [Macromedia][Oracle JDBC Driver][Oracle]ORA-29532: Java call terminated by uncaught Java exception: java.lang.NullPointerException ORA-06512: at 'SYS.DBMS_XMLQUERY', line 26 ORA-06512: at 'WHBPS.GETXMLDATA', line 4 ORA-06512: at line 1

Thanks!
Mike Received on Mon Jan 09 2006 - 12:13:15 CST