Re: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

I am getting the very same error when our application migrated to 10g. In 9i we were fine and the "Same" Stored procedures worked fine. A temporary workaround I figured was to put a TRIM in every place where I am using MIN or MAX against a CHAR Column.

Need to know the cause though of the same.

Dereck L. Dietz wrote:
> > > What I don't understand however, is that if I cut and paste the insert
> with
> > > the cursor text underneath it into a SQL*PLUS window and run it it will
> run
> > > to completion. I only get this error when I run it from within my
> PL/SQL
> > > package.
> >
> > One obvious difference is that in SQL*Plus you are not doing a
> > SELECT INTO v_in and piping v_out. Look at how these are defined.
> > --
> > Daniel A. Morgan
> > University of Washington
> > damorgan_at_x.washington.edu
> > (replace x with u to respond)
> > Puget Sound Oracle Users Group
> > www.psoug.org
>
> Okay thanks. I'll take another look at everything tomorrow at work when
> I've had time to refresh my mind.
Received on Wed Nov 29 2006 - 01:33:45 CST