RE: Dba's i have a problem running dbms packages

  • From: "Ken Naim" <kennaim@xxxxxxxxx>
  • To: <vincent.verpoort@xxxxxxxxx>, "'Oracle-L Freelists'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 19 Oct 2006 04:24:11 -0500

While I don't have experience with this particular issue, based similar
issues though I would guess that your sys/system packages are either corrupt
or uncompiled for whatever reason. I would start by running utlrcmp and if
that doesn't work rerun catalog, catproc, and utlrcmp as sys. Depending on
the version deleting database statistics has been known to help with this
type of issue on occasion.
 
Ken
 
  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Vincent verpoort
Sent: Thursday, October 19, 2006 4:13 AM
To: Oracle-L Freelists
Subject: Dba's i have a problem running dbms packages
 
While running dbms stuff im getting this error and well i can find anything
on internet how to solve this only that allot of poeple are having this
problem.

Any tips ? 

BEGIN DBMS_OUTPUT.ENABLE(100000); END;

*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-06553: PLS-801: internal error [56319]
ORA-06553: PLS-801: internal error [56319]


-- 
                           Vincent Verpoort 

  ,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_,.-~`"'~-.,_ 
              Communiceren is begrepen worden 
^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-. 

Other related posts: