Path: news.easynews.com!easynews!feedwest.aleron.net!aleron.net!sfo2-feed1.news.algx.net!allegiance!news-hog.berkeley.edu!ucberkeley!news.maxwell.syr.edu!fr.clara.net!heighliner.fr.clara.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: shared pool problem
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: <11y49.54906$8o4.7434@afrodite.telenet-ops.be>
Date: Thu, 08 Aug 2002 17:39:09 GMT
NNTP-Posting-Host: 213.118.145.167
X-Complaints-To: abuse@telenet.be
X-Trace: afrodite.telenet-ops.be 1028828349 213.118.145.167 (Thu, 08 Aug 2002 19:39:09 MET DST)
NNTP-Posting-Date: Thu, 08 Aug 2002 19:39:09 MET DST
Organization: Telenet Internet
Xref: easynews comp.databases.oracle.misc:85327
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?