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

Home -> Community -> Usenet -> c.d.o.server -> Shared pool problem

Shared pool problem

From: Gerrit Daluwein <gerrit.daluwein_at_pandora.be>
Date: Thu, 08 Aug 2002 17:39:09 GMT
Message-ID: <11y49.54905$8o4.7367@afrodite.telenet-ops.be>


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? Received on Thu Aug 08 2002 - 12:39:09 CDT

Original text of this message

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