Path: news.easynews.com!easynews!news.infoave.net!skynet.be!skynet.be!ossa.telenet-ops.be!afrodite.telenet-ops.be.POSTED!not-for-mail
From: "Gerrit  Daluwein" <gerrit.daluwein@pandora.be>
Newsgroups: comp.databases.oracle.misc
Subject: ALTER SYSTEM FLUSH SHARED_POOL
Lines: 10
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <21y49.54907$8o4.6816@afrodite.telenet-ops.be>
Date: Thu, 08 Aug 2002 17:39:10 GMT
NNTP-Posting-Host: 213.118.145.167
X-Complaints-To: abuse@telenet.be
X-Trace: afrodite.telenet-ops.be 1028828350 213.118.145.167 (Thu, 08 Aug 2002 19:39:10 MET DST)
NNTP-Posting-Date: Thu, 08 Aug 2002 19:39:10 MET DST
Organization: Telenet Internet
Xref: easynews comp.databases.oracle.misc:85328
X-Received-Date: Thu, 08 Aug 2002 10:36:15 MST (news.easynews.com)

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?