Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL help urgent..
On Mon, 16 Mar 1998 19:35:12 -0500, AMARPREET S PAHWA <apahwa_at_voyager.net> wrote: Hi,
posting the error number as well would have been nice. One cause might be that you defined a variable as - let's say - number(2) and during execution you reach a point where yout try to assign a 3 digit value to this variable.
>PB 4.0.3 and using Oracle 7.3.3 has a backend, and I am executing a
>stored procedure from PB. My problem is Stored procedure runs fine till
>certain time and after that I start getting the "PL/SQL numeric value
>error". If we shutdown the database and restart the problem is gone.
>
>Well it looks very strange to me, I am sure we are missing something.
>
>Any help will be appreciated .
>
>Thanks in advance
>AMAR
-- Regards Matthias Gresz :-) GreMa_at_T-online.deReceived on Tue Mar 17 1998 - 00:00:00 CST