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

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

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Fri, 03 Nov 2006 02:09:55 GMT
Message-ID: <Txx2h.3863$B31.798@newssvr27.news.prodigy.net>

> > 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 Thu Nov 02 2006 - 20:09:55 CST