What is the script to create DBMS_STANDARD package?

[Shyamis]

Hello pals,

I installed Oracle 8.1.7.0.0 on Windows NT, I added Oracle Web DB to it. After installing everything I realised some of my DBMS packages were missing and when I tried to run catalog.sql and catproc.sql I got a few error messages.

One such error message says

ORA-06554: package DMBS_STANDARD must be created before using PL/SQL

I guess I cannot create the DBMS_APPLICATION_INFO without creating DBMS_STANDARD.

What is the script that I run to create the above and other missing packages?

Thanks in advance,
-Shyami

[sandycrab]

Normally all the packages are installed during running catproc.sql but as you said you faced some problem while running catproc.sql, try running dbmsapin.sql. Before that are you sure you are running scripts in sys schema...
Sandy

[Shyamis]

Thanks Sandycrab!

I still have a problem though!! The script tries to create DBMS_APPLICATION_INFO ! I get an error saying so I have to find the script to create DBMS_STANDARD first

ORA-06554: package DBMS_STANDARD must be created before using PL/SQL

As an add on... I found the Dbmsstdx.sql but I get error messases when I run this!

ORA-06553: PLS-213: package STANDARD not accessible

I used standard.sql to create the STANDARD package and I get

Warning: Package created with compilation errors

ORA-06553: PLS-213: package STANDARD not accessible

And if I try to compile STANDARD through TOAD I get

The following error has occurred:

PACKAGE SYS.STANDARD
On line: 0
PLS-00707: unsupported construct or internal error [2603]



Details:
PACKAGE SYS.STANDARD
On line: 0
PLS-00707: unsupported construct or internal error [2603]

Do I have to install the whole stuff again?

Help!!!

have a nice day,
-Shyami




[Edited by Shyamis on 08-29-2002 at 12:34 PM]

[stmontgo]

what user are u running these scripts as?

if you have ever run them as any other user than sys than you have objects that need to be removed. If you ran these scripts as SYSTEM you are in the same boat.

steve

[sandycrab]

Do one thing...run catalog.sql and catproc.sql again . Plz make sure you are running these scripts in SYS schema.
Sandy

[Shyamis]

I am running these scripts as SYS. Will try running the catlog.sql and catproc.sql scripts again and let you guys know. Thanks for all the replies.

have a nice day,
-Shyami