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
