Error in xml functions

From: <devjnr_at_gmail.com>
Date: 28 Nov 2006 01:29:14 -0800
Message-ID: <1164706154.146981.94300@l12g2000cwl.googlegroups.com>

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. Received on Tue Nov 28 2006 - 03:29:14 CST