Re: ORA-06553: Who was first the egg or the chicken?

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: Thu, 07 Feb 2002 11:50:41 +0400
Message-ID: <0dc46u0kcj3nqa3u755chmpah9s0dglq7i@4ax.com>

On Thu, 07 Feb 2002 06:24:58 GMT, "Alvaro Fuentes" <alvarof2_at_hotmail.com> wrote:

>
>Fellow Oracle Netters:
>
>
>System: Solaris 8 running Oracle9i Enterprise
>
>I tried to drop a table and got:
>ORA-06553 Package STANDARD not accessible.
>
>I tried to run as a SYS:
>$ORACLE_HOME/rdbms/admin/standard.sql
>
>SQL> get standard.sql
>
>1 @@stdspec.sql
>2 @@stdbody.sql
>3* grand EXECUTE on STANDARD to public
>SQL> /
>
>getting:
>
>"ERROR at line 1:
>Invalid SQL statement"
>
>
>Now, I tried to run first stdspec.sql and came with the errors:
>
>ORA-00604 Error ocurred at recursive SQL level 1
>ORA-06553 Package STANDARD not accessible
>
>Any help how to solve this issue will be greatly appreciated.
>
>
>Thanks
>
>A. Fuentes
>afuentes_at_goodpremises.com
>512-297-9937
>
>
>

That Was a Million Dollar Question... Did u Try Running CatProc.sql again.. why dont u try that ...

[Additions and Corrections Always Welcome.] Best Regards,
Ganesh R Received on Thu Feb 07 2002 - 01:50:41 CST