strange - PLSQL Hang with CLOB column

[shayt]

hi,

my table : table_with_clob
has some columns, one of them is CLOB.

in one DB (only one ! )
when i do
select * from table_with_clob;
in PLSQL 7.0.1.1066, the transaction hang.

but in TOAD, SQLPLUS it's OK.

i tried to do the same thing in a different DB, and strange - it works in PLSQL program !

so probably PLSQL Developer have some kind of a problem with something which is different in the two DBs.

i compared NLS_PARAMETERS and they are the same.
both DBs are Oracle 9.

can you give me some directions how to solve it.

Thanks,
Shay

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

 

[shayt]

OK,

i sent the file to the support email.

Shay

 

[hbar]

I am having a similar problem, but the results seem to be unpredictable. Sometimes I can query the clob table...but sometimes PL/SQL Developer will throw Access Violations from module 'orageneric10.dll'. Other times it will "hang" indefinitely. That is, the old girl is still responsive, but the clob query will not complete, and can not be killed; the app must be end-tasked. This has been known to happen even if the query does not return any rows.

I have likewise sent my debug info to support. Thanks.

 

[hbar]

Hmmmm, it appears the hanging is very much related to whether or not I include ROWID in the select statment. Of course, it's tough to use the large data editor w/o also using ROWID.