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

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Thu, 19 Oct 2006 15:10:37 +0100
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC1663B64F@ENYC11P32005.corpny.csfb.com>

This can also occur if you have migrated a database created with 32-bit Oracle software to 64-bit Oracle software.

There's a MetaLink note, 62290.1, on this--basically you want to

Paul Baumgartel
CREDIT SUISSE
Information Technology
DBA & Admin - NY, KIGA 1
11 Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Ken Naim Sent: Thursday, October 19, 2006 5:24 AM To: vincent.verpoort_at_gmail.com; 'Oracle-L Freelists' Subject: RE: Dba's i have a problem running dbms packages

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

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

Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html

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

Received on Thu Oct 19 2006 - 09:10:37 CDT