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

Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-06502: PL/SQL: numeric or value error

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

From: Christopher Boyle <cboyle_at_hargray.dot.com>
Date: Fri, 9 Aug 2002 09:35:20 -0400
Message-ID: <aj0gem$cfcf$1@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 Fri Aug 09 2002 - 08:35:20 CDT

Original text of this message

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