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

Home -> Community -> Usenet -> c.d.o.misc -> 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.54906$8o4.7434@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