Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ALTER SYSTEM FLUSH SHARED_POOL
On Thu, 08 Aug 2002 17:39:10 GMT, "Gerrit Daluwein"
<gerrit.daluwein_at_pandora.be> 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?
>
>
>
Your many posts are in vain without the affected pl/sql code. This is
*NOT* a shared pool problem.
Regards
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Thu Aug 08 2002 - 13:00:00 CDT