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