Re: DBMS_SYS_SQL creating package failsl

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Thu, 18 Mar 1999 16:06:29 +0800
Message-ID: <36F0B405.5F36@bhp.com.au>

Amy Davidson wrote:
>
> DBA's,
>
> I'm using 7.3.4.Oracle on an NT workstation 4.
> I create a database via the Oracle NT instance manager.
> The script catalog.sql and catproc.sql are run automatically.
>
> During one of these scripts, the package DBMS_SYS_SQL
> is created but it is created with compilation errors.
> I tried to recompile but keep getting the error:
> sys.DBMS_SQL must be declared.
>
> Is there a patch that I'm missing?
>
> Your help would be appreciated.
>
> Regards,
> Amy

Look under $ORACLE_HOME/rdbms/admin

the package: dbmssql.sql and prvtsql.sql

Run these to create "DBMS_SQL" and see how you go...

HTH
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"Never wrestle a pig - you both get dirty and the pig likes it..." Received on Thu Mar 18 1999 - 02:06:29 CST