Re: Shared pool problem

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 08 Aug 2002 19:40:12 GMT
Message-ID: <3D52C917.BAC43098@exesolutions.com>

Gerrit Daluwein wrote:

> 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?

What in your posting do you think anyone wanting to help you could possibly use as the basis of a response?

Hardware platform? No!
Operating system? No!
Oracle database version? No!
Oracle database edition? No!
SQL being executed? No!
What other SQL statements are being executed? No! Table definitions? No!
initSID.ora parameters? No!
Have you invested any effort at any of the Oracle support web sites? Can't tell!

Have you done anything yourself to try to identify the problem? Can't tell!

Daniel Morgan Received on Thu Aug 08 2002 - 14:40:12 CDT