Not able to view CLOB data

[Sunita James]

I have a table where one of the columns is a CLOB.

In SQL Window, when I type
select * from

;
PL/SQL developer displays for the data under the CLOB column.

How do I get PL/SQL developer to display the CLOB data ?

I have 2 databases. When I connect to one, the query displays the CLOB. But when I connect to the other one, the query displays

Regards,
Sunita.

 

[Marco Kalter]

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

 

[jmarks2001]

I am also experiencing this error. I'm using PL/SQL Developer version 7.0.1.1066, but I don't think my problem is with the software.

A majority (about 80%) of the records in a table that uses a CLOB column to store XML are being returned with "" in PL/SQL. These same records are erroring when trying to access them through a java web app via JDBC, the other 20% are working fine.

I think it's some type of data corruption at the oracle level. However, if someone has any insight into the problem, I'd like to hear your thoughts.

Thank god it's only my testing environment.