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

Thanks for the suggestion.

I ran $ORACLE_HOME/rdbms/admin/catproc.sql

and the script asks for;

"Enter the prvttypu value: "

I have no idea what value is asking for.

I know there is a HUGE file prvttypu.plb in the same directory of catproc.sql

Again, any help on what enter for prvttypu will be greatly appreciated.

Thanks

1. Fuentes 512-297-9937

"Ganesh Raja" <ganesh_at_gtfs-gulf.com> wrote in message news:0dc46u0kcj3nqa3u755chmpah9s0dglq7i_at_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 - 10:51:04 CST