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

From: Ken Naim <kennaim_at_gmail.com>
Date: Thu, 19 Oct 2006 04:24:11 -0500
Message-ID: <000b01c6f360$573f3d10$85e7cf48@KenHome>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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

^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-._,.->*^*<-.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 19 2006 - 04:24:11 CDT