XML Objects

[Gaz]

Hi

I'm using 8.0.4 and am having trouble viewing XML objects in PL/SQL Developer, for example I create a table with one column of an xml type, insert some data, but on selecting from the table the GUI tool shows 1 row, but no information on screen. Is anyone else having this problem and is there a workaround?

CREATE OR REPLACE TYPE ft_arrival_obj AS OBJECT (
financial_transaction_xml sys.xmltype
);

-- Create table
create table FT_CHEQUE_OBJECT
(ft_xml FT_ARRIVAL_OBJ)

Similarly, in tables with more regular columns and an xml column, the toll with display all columns except the one with XML in it.

Any help appreciated

Cheers

Gaz

 

[Theod]

Hi,

did you check the column by hitting the '...'-Button and there the xml-Tab?

 

[Gaz]

Hi Theod

I know what you mean, but that not the issue I'm experiencing. From some objects (such as queue views) when I've run a query I get a returned column (which I think is what you're talking about and it has a text label and elipsis (...))

PNS_XML
1 ...
2 ...

This will return a pop up window with all the valid values in there.

In other cases though, when I run the query, it returns rows, but nothing in the results window except the row numbers in the gutter:

PNS_XML
1
2

I can prove the query returns other values by selecting different columns - the tool will display columns for regular datatypes (VARCHAR2, NUMBER etc), but the column for XML will be missing from the result set.

Thanks

Gaz