Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: XMLQuery returning Java Exception

Re: XMLQuery returning Java Exception

From: Michael O'Shea <michael.oshea_at_tessella.com>
Date: 9 Jan 2006 12:21:27 -0800
Message-ID: <1136838087.658658.110790@f14g2000cwb.googlegroups.com>

In the PL/SQL you posted, excerpt below

> queryCtx := DBMS_XMLQuery.newContext(sqlstring);

note you can almost literally substitute the use of DBMS_XMLQuery (java) for DBMS_XMLGen (native).

eg.

 queryCtx DBMS_XMLGen.newContext(sqlstring);

I'd be inclined to quickly migrate the offending code and then see if the error still occurs. You might get yourself out of the woods quicker than a tar.

Regards
Mike

TESSELLA Michael.OShea_at_tessella.com

__/__/__/  Tessella Support Services plc
__/__/__/  3 Vineyard Chambers, ABINGDON, OX14 3PX, England
__/__/__/  Tel: (44)(0)1235-555511  Fax: (44)(0)1235-553301
www.tessella.com Registered in England No. 1466429 Received on Mon Jan 09 2006 - 14:21:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US