? PL/SQL: numeric or value error: character string buffer too small

hi,

i have two tables, that contain clobs.

while this statement is ok:
select nummer from altdaten where
instr(lower(dbms_lob.substr(BEMERKUNG_FUER_KREDI)), 'boy') > 0;

this statement:
select id from beschluss where
instr(lower(dbms_lob.substr(beschluss_text)), 'boy') > 0; returns
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1

btw. the table altdaten is the BIGGER table, but has no foreign keys.

anybody any idea?

thanks in advance Received on Wed Jul 04 2001 - 09:17:05 CDT