Path: news.easynews.com!easynews!cyclone.swbell.net!cyclone-sf.pbi.net!128.32.206.55!newsfeed.berkeley.edu!ucberkeley!logbridge.uoregon.edu!news-west.eli.net!not-for-mail Message-ID: <3D52C917.BAC43098@exesolutions.com> From: Daniel Morgan X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.server Subject: Re: Shared pool problem References: <11y49.54905$8o4.7367@afrodite.telenet-ops.be> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 28 Date: Thu, 08 Aug 2002 19:40:12 GMT NNTP-Posting-Host: 156.74.250.7 X-Complaints-To: yvonne.tracy@ci.seattle.wa.us X-Trace: news-west.eli.net 1028835612 156.74.250.7 (Thu, 08 Aug 2002 13:40:12 MDT) NNTP-Posting-Date: Thu, 08 Aug 2002 13:40:12 MDT Organization: City of Seattle NewsReader Service Xref: easynews comp.databases.oracle.server:157296 X-Received-Date: Thu, 08 Aug 2002 12:37:23 MST (news.easynews.com) 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? What in your posting do you think anyone wanting to help you could possibly use as the basis of a response? Hardware platform? No! Operating system? No! Oracle database version? No! Oracle database edition? No! SQL being executed? No! What other SQL statements are being executed? No! Table definitions? No! initSID.ora parameters? No! Have you invested any effort at any of the Oracle support web sites? Can't tell! Have you done anything yourself to try to identify the problem? Can't tell! Daniel Morgan