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 -> XMLQuery select gives "PLS-00801: internal error"

XMLQuery select gives "PLS-00801: internal error"

From: Gerry Atric <f_at_t.chance.com>
Date: Fri, 24 Mar 2006 17:07:11 GMT
Message-ID: <3HVUf.7353$%H.3740@clgrps13>


I take it this means Oracle does not do implicit casting between xmltype and varchar2? I don't see why this is not possible... an implicit cast could just copy the xmltype stuctured data into a varchar2 (or clob).

The version is Oracle 10gR2 Standard running on RHAS4.


"Error(71,2): PLS-00801: internal error [*** ASSERT at file pdw4.c, line 793; Cannot coerce between type 43 and type 30;"


procedure xmltest as

xmldata xmltype := xmltype('<packet><data>some data</data></packet>'); xmlresult varchar2(4000);

begin

select xmlquery('for $a in $doc/packet/data return <data>{$a}</data>' passing xmldata as "doc" returning content) into xmlresult from dual;

end;


Received on Fri Mar 24 2006 - 11:07:11 CST

Original text of this message

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