Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: ? PL/SQL: numeric or value error: character string buffer too small

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

From: Markus Stuhlpfarrer <mstuhlpfarrer_at_hollomey.com>
Date: Wed, 04 Jul 2001 14:33:44 GMT
Message-ID: <3B43450D.7DCBDA0B@hollomey.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US