Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ALTER SYSTEM FLUSH SHARED_POOL

Re: ALTER SYSTEM FLUSH SHARED_POOL

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 08 Aug 2002 20:00:00 +0200
Message-ID: <mbc5lu4renuul3b2vnk6aq28btf7958oaa@4ax.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US