Re: Error in xml functions

devjnr_at_gmail.com schrieb:
> I'm trying to exec this query on Ora v10.2G:
>
> select
> doc_id,
> EXTRACT(xml_data, '/FAQ-LIST/QUESTION') "Question 1"
> from
> XMLTable;
>
> XMLTable contains one row with 2 columns:
>
> doc_id number = 1;
> xml_data xmltype = '<FAQ-LIST>
> <QUESTION>
> <QUERY>Question 1</QUERY>
> <RESPONSE>Answer goes here.</RESPONSE>
> </QUESTION>
> </FAQ-LIST>'
>
> When I query from sql/plus it works great.
>
> But when I try to use:
>
> - PL/SQL Developer (OCI 8) I obtain this error:
>
> OCI-21500: internal error code, arguments: [58],[],[],[],[],[],[],[]
> OCI-21500: internal error code, arguments:
> [kghfrh:ds],[0x2D87AF0],[],[],[],[],[],[]
>
> - TOAD (OCI 7) I obtain this error:
>
> OCI 8 is required
>
> Now, I have to debug some complex xml webservices and I should can
> debug with PL/SQL Dev eloper...but I can't go deeper because of these
> strange errors...
>
> Can you hrlp me? A google search didn't help me.
>
> Regards.
>

AFAIK the latest version of PL SQL Developer don't produces this error. If you state a problem, which occurs in Pl Sql Developer and don't occurs in sqlplus it is always a good idea to look in the Pl Sql Developer Forum (http://www.allroundautomations.com/plsqldev.html), in particular, the error you mention was often discussed there. As a workaround you can use

SELECT doc_id, EXTRACT(xml_data, '/FAQ-LIST/QUESTION').getClobVal() "Question 1"
FROM XMLTable;

Best regards

Maxim Received on Tue Nov 28 2006 - 05:27:09 CST