Re: PB6.5/Oracle 8.0.4 numeric of value error

davidmguest_at_hotmail.com (davidmguest) wrote in message news:<d9ab5656.0202150234.20a5220c_at_posting.google.com>...
> It looks like there may be an inconsistency in the way that a default
> value or format is applied, which could generate the error.
>
> Are you explicitly setting values for all parameters and variables?
>
> Hope this Helps
>
> David Guest

Thanks for the help David.

We found the problem.

It had nothing to do with code. Apparently there are some memory leaks in something connecting to the database. The DBA cleared the SGA buffer and the problem cleared up. Very strange though because not all of the Stored Procs were having a problem, only 2 of them. Received on Tue Feb 19 2002 - 14:10:53 CET