What is causing this error. Please help

[D R O]

I've been stuck on this problem for most of the day. Anyone know why i keep getting the error

"ORA-00604: error occured at recursive SQL level 1
ORA-06553: PLS-213: package STANDARD not accessible"

I'm using OraHome90. I get this error when i try and create a new table or try to delete one. Can someone please help me out? Thank you.

[pando]

run catproc.sql

[D R O]

Thanks for responding. This is my second day using oracle. Our oracle dba left for 2 months and i got assigned his job. Where in OraHome90 do i run that?

[Mnemonical]

/OraHome90/rdbms/admin/catlproc.sql


F.

[D R O]

i found the catproc.sql but where do i run it. I have Oracle SQL *Plus...is that where i do it. Do i just type

run catproc.sql?

what program do i use? Thanks a lot people!!!

[marist89]

sqlplus / as sysdba
@c:\whatever\catalog.sql

[D R O]

I ran the catproc.sql script in sql plus as sysdba and when the script was running it kept saying it was unable to open all these files. I ran this script on the oracle server. Do i need to run this on my client machine. I went to go delete a table and i still received the error. Anything else i should be doing or does anyone have anymore advice so i can fix this problem

[pando]

I suggest you search the server and look for catalog.sql

[D R O]

i ran the catalog.sql in sql plus. When the program was running the script it kept flashing the same error that i'm trying to fix. After i ran the script i tried to add/delete table and i got the same error. Is there another script i need to run. Appreciate the help you people have been giving me.

[pando]

ok I am totally lost now

what errors are you getting

have you ran the script as user SYS? and where have you found the script?

this is the most basic thing... running a script so I cant imagine what can go wrong

plus I said catproc.sql although I make a pardon in my last post I mentioned catalog.sql coz I was looking mariest's post