Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: ? PL/SQL: numeric or value error: character string buffer too small
at least 1 element in the column beschluss_text seams to be longer than
varchar2 can be (about 32600)
so you need either cut the column beschluss_text to that size (which
would eventually influence your result)
or you use DBMS_LOB.INSTR instead of making a varchar out of it and making
a normal instr
Alexander Knack wrote:
> 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:33:44 CDT