Hello Andreas, I had faced a similar problem where the destination variable
was smaller in size than the data coming in. I increased the size of the
destination variable and everything became fine....... have u tried this?
----- Original Message -----
From: Andreas Jung <ajung_at_sz-sb.de>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Wednesday, May 24, 2000 10:44 AM
Subject: Re: PL/SQL: character string buffer too small
> On Wed, May 24, 2000 at 02:53:47AM +0000, Rajagopal Venkataramany wrote:
> > Hi,
> >
> > In PL/SQL, you can define varchar2 datatype to be of length 32767
> > (max). The limit of 4000 is when the datatype is used in table
> > creation.
> What shall I do with this answer ?! It has nothing to do
> with my question. So read first, then answer.
>
> Andreas
> --
> Author: Andreas Jung
> INET: ajung_at_sz-sb.de
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed May 24 2000 - 00:22:03 CDT
