Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-06553: PLS-707: unsupported construct or internal error [2603]
Stefan
I've recently inherited this database and the developers who have used the database in the past say that it worked fine and they have had no problems.
My first reaction was the same as yours but i'm assured by the developers that this database has worked fine before.
The problem is the previous DBA has left and there is no documentation on the database.
>From: Stefan Jahnke <stefan.jahnke_at_d2vodafone.de>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: ORA-06553: PLS-707: unsupported construct or internal error
>[2603]
>Date: Thu, 10 May 2001 06:31:12 -0800
>
>zabair ahmed schrieb:
> >
> > Has anybody seen the following error on logon to sqlplus
> >
> > >sqlplus dbu/dbu
> >
> > SQL*Plus: Release 8.1.7.0.0 - Production on Thu May 10 14:29:27 2001
> >
> > (c) Copyright 2000 Oracle Corporation. All rights reserved.
> >
> > ERROR:
> > ORA-06553: PLS-707: unsupported construct or internal error [2603]
> >
> > Error accessing package DBMS_APPLICATION_INFO
> > ERROR:
> > ORA-06553: PLS-707: unsupported construct or internal error [2603]
> >
> > Connected to:
> > Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> > With the Partitioning option
> > JServer Release 8.1.7.0.0 - Production
> >
> > SQL> show user
> > USER is "DBU"
> > SQL>
> >
> > There are a number of invalid views belonging to SYS.
> >
> > SYS.GV_$ARCHIVED_LOG
> > SYS.GV_$BACKUP_DATAFILE
> > SYS.GV_$BACKUP_PIECE
> > SYS.GV_$DATAFILE_COPY
> > SYS.GV_$DISPATCHER_RATE
> > SYS.GV_$LOCK_
> > SYS.GV_$MTS
> > SYS.GV_$PROXY_ARCHIVEDLOG
> > SYS.GV_$PX_SESSTAT
> > SYS.V_$DISPATCHER_RATE
> > SYS.V_$BACKUP_SET
> > SYS.V_$BACKUP_PIECE
> > SYS.V_$ARCHIVED_LOG
> > SYS.GV_$TEMP_EXTENT_MAP
> > SYS.GV_$SYSTEM_PARAMETER
> > SYS.GV_$SORT_USAGE
> > SYS.GV_$SGASTAT
> > SYS.GV_$SESSION
> > SYS.V_$SESSION
> > SYS.V_$ROLLNAME
> > SYS.V_$PROXY_DATAFILE
> > SYS.V_$PROXY_ARCHIVEDLOG
> > SYS.V_$MTS
> > SYS.V_$LOADPSTAT
> > SYS.GV_$PROXY_DATAFILE
> > SYS.GV_$PARAMETER
> > SYS.GV_$MLS_PARAMETERS
> > SYS.GV_$LOADPSTAT
> > SYS.GV_$DELETED_OBJECT
> > SYS.GV_$BACKUP_SET
> >
> > When i try to recompile these i get the following error messge
> >
> > SQL> alter VIEW SYS.V_$BACKUP_PIECE compile;
> >
> > alter VIEW SYS.V_$BACKUP_PIECE compile
> > *
> > ERROR at line 1:
> > ORA-00604: error occurred at recursive SQL level 1
> > ORA-00904: invalid column name
> >
> > Anybody seen this before i had a quick look in Metalink but couldn't
>find
> > anything useful.
> >
> > Oracle 8.1.7.0.0 on Solaris 5.6
> >
> > TIA
> >
> > Zabair
>
>Hi,
>
>has your dictionary been created correctly during database creation ?
>Did you run catalog and catproc and whatever else you need without any
>errors ?
>Looks like some stuff is missing.
>
>--
>Regards,
>Stefan Jahnke
>BOV AG
>@:D2 Vodafone, Abt.: FIBM
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Stefan Jahnke
> INET: stefan.jahnke_at_d2vodafone.de
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zabair ahmed INET: zabaira_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu May 10 2001 - 09:37:20 CDT