Re: ORA-06502: PL/SQL: numeric or value error

It's possible your problem is code related. If not there are Oracle 7.x bug reports addressing this issue. (#418302, #516664, #535798 or search Oracle metalink). I've experienced this problem with version 8.0.3. These bugs are usually seen when the shared pool is heavily loaded. Alter system flush shared_pool usually gives temporary relief. Recompiling the package or stored procedure will also fix the problem.

Scott Niese
Westfaro Corporation
www.westfaro.com
Making Sense of Software

"Christopher Boyle" <cboyle_at_hargray.dot.com> wrote in message news:aj0gem$cfcf$1_at_news3.infoave.net...
> You are either exceeding the space allowed for the variable , trying to
> place a 5 character value into a field defined as varchar(4) or you are
> trying to convert something that can not be done such as placing 123A
into
> a field defined as a number. You might look at defining your variables as
> table.column%TYPE if you aren't already
>
>
> "Gerrit Daluwein" <gerrit.daluwein_at_pandora.be> wrote in message
> news:11y49.54904$8o4.7330_at_afrodite.telenet-ops.be...
> > I am getting ORA-06502: PL/SQL: numeric or value error when calling a
> stored
> > procedure in a package ( the procedure accepts three parameters and uses
> > these to insert a row in a table. )
> >
> > When i execute ALTER SYSTEM FLUSH SHARED_POOL the problem is solved, but
> > after some time i get the same error again.
> >
> > Can anyone please help?
> >
> >
>
>
Received on Sat Aug 10 2002 - 09:11:51 CDT