CLOB size limit !

[mobermaier]

I have a table with 5 clob columns (see below), when I load data into those clobs and try to run the following command

select * from OPERA_SHELL
or (all columns specified)
select name, version, upload_date, sys_lob, cro_lob, chn_lob, prp_lob, rep_lob from OPERA_SHELL

PL-SQL Developer crashes !!

Version 7.0.1.1066 (MBCS)
OCI: Version 9.0
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Character size: 3 byte(s)

Table:

CREATE TABLE "OPERA_SHELL"
( "NAME" VARCHAR2(80) NOT NULL ENABLE,
"VERSION" VARCHAR2(30),
"UPLOAD_DATE" DATE NOT NULL ENABLE,
"SYS_LOB" CLOB NOT NULL ENABLE,
"CRO_LOB" CLOB NOT NULL ENABLE,
"CHN_LOB" CLOB NOT NULL ENABLE,
"PRP_LOB" CLOB NOT NULL ENABLE,
"REP_LOB" CLOB NOT NULL ENABLE )

the following statements work fine:

select * from OPERA_SHELL where name ='TEST'
NO ROW

select name,
version,
dbms_lob.getlength(SYS_LOB) as LSYS,
dbms_lob.getlength(CRO_LOB) as LCRO,
dbms_lob.getlength(CHN_LOB) as LCHN,
dbms_lob.getlength(PRP_LOB) as LPRP,
dbms_lob.getlength(REP_LOB) as LREP
from opera_shell

Result:

KAYAST 4.0.30.00 35719746 483109 342503 2044061 168580

It seems that the first clob SYS_LOB is too big (~34MB)

the query:

select name, version, upload_date, cro_lob, chn_lob, prp_lob, rep_lob from OPERA_SHELL

returns one row w/o problem

 

[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.