Querying XMLTYPE objects

[Rob Milne]

First off, let me say I am enjoying working with PL/SQL Dev. very much. Thanks!

I've just started exploring XML DB, and am working through the demo at http://www.oracle.com/technology/sample_code/tech/xml/xmldb/XDBBasicDemo.pdf.

I can run an SQL statement like this

select value(x) from purchaseorder x
where existsNode( value(x), '/ElementName="someValue"]') =1

in SQLPlus on AIX 5.3 and I get output showing the document contents (in the DB it is stored as a row in the XMLType table named "purchaseorder").

However, in PL/SQL Dev it returns in the SQL window and "Object" in the command window.

Maybe this isn't a fair question because Oracle's SQL Developer doesn't handle it either! That returns SYS.XMLTYPE.

Is there a solution for this?

 

[Marco Kalter]

Can you let me know your PL/SQL Developer version?

 

[Rob Milne]

PL/SQL Developer
Version 7.1.0.1337
10 user license
Windows XP Professional 5.1 Build 2600 (Service Pack 2)

 

[Marco Kalter]

It's most likely an Oracle client or server bug. Can you let me know your client and server version?

 

[CBennett]

I have had exactly the same thing reported to me but only on a 10g DB, the same data on 9i is fine, doing to_clob shows the XML. The question is - is PL/SQL Dev trying to format the XML when the source DB is 10g, if so what is it getting wrong or thinks is invalid. Nothing else seems to have a problem with it and what does Value Error mean exaclty. The client and server are both 10g when we see this.

 

[CBennett]

I have been told this was sorted by installing version 7.1 of PL/SQL. Sorry to bother you I though they had done that already.