More info: dbmsstdx.sql causes ORA-04045 errors

I guess the problem is that dbmsstdx.sql created the package spec, but not the package body. No wonder why it is complaining...

How do I create dbms_standard's package body?

Thanks,
Ivan.

Ivan Vasquez wrote:

> Hi,
>
> I'm new to Oracle database administration. Reading Oracle 9i's
> documentation for CREATE FUNCTION, there is a line that states:
>
> "Before a stored function can be created, the user SYS must run a SQL
> script that is commonly called DBMSSTDX.SQL."
>
> My database was working fine, but once I executed this script, I started
> getting errors everywhere similar to these:
>
> ORA-04045: errors during recompilation/revalidation of LBACSYS.LBAC$LOGON
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at line 2
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at line 2
>
> The message appears not only for LBACSYS.LBAC$LOGON but for basically
> everything that (possibly) requires compilation (such as compiling a
> user-stored procedure).
>
> Is it possible to "undo" this script without re-creating the database?
>
> Thanks in advance,
> Ivan.
>
Received on Sun Apr 21 2002 - 00:51:12 CDT