Path: news.easynews.com!easynews!sn-xit-02!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: Sybrand Bakker Newsgroups: comp.databases.oracle.misc Subject: Re: ALTER SYSTEM FLUSH SHARED_POOL Date: Thu, 08 Aug 2002 20:00:00 +0200 Organization: Posted via Supernews, http://www.supernews.com Message-ID: Reply-To: postbus@sybrandb.demon-verwijderdit.nl References: <21y49.54908$8o4.7505@afrodite.telenet-ops.be> X-Newsreader: Forte Agent 1.91/32.564 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: newsabuse@supernews.com Lines: 23 Xref: easynews comp.databases.oracle.misc:85330 X-Received-Date: Thu, 08 Aug 2002 10:56:38 MST (news.easynews.com) On Thu, 08 Aug 2002 17:39:10 GMT, "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? > > > 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