Re: dbms_lock package (help, I ran a script to replace it!)

Hello

just use the next script-generator as sys and execute the result as long as there are invalid procedures, functions and packages:

        select 'alter '||object_type||' '||object_name||' compile;' from all_objects where status <> 'VALID'

                and object_type in ('PROCEDURE', 'FUNCTION', 'PACKAGE');
as the next use the following statement the same way:
        select 'alter package '||object_name||' compile body;' from
all_objects where status <> 'VALID'
                and object_type = 'PACKAGES BODY');

much luck
Reimar

dorine_r_perry_at_navtrans.navy.mil schrieb in Nachricht <6hj434$r60$1_at_nnrp1.dejanews.com>...
>First, let me say that I am not a DBA... I am an applications developer,
but
>my company is without a DBA and we are on our own right now. While trying
to
>fix a problem with undeleted locks, I ran a script called dbmslock.sql,
that
>comes with Oracle 7.3. The script went out and replaced the sys.dbms_lock
>package and created a synonym dbms_lock to point to it.
>
>Everything appeared to be ok, until we tried to go into Designer 2000 and
>change the data diagrammer. We can view the diagrams, but when we try to
>update ANYTHING in the repository, we get these error messages:
>
>RME-00223: Failed to open new activity
>RME-00222: Failed to dispatch operation to Repository
>RME-00011: Operation 'open' on ACTIVITY has failed
>RME-00854: Activity package initialisation failed
>
>I am not sure if they are caused by what I have done, but when I look into
the
>cause of the error it does mention system packages and specifically the
>API.
>
>Does anybody know if I can restore the dbms_lock package the same way I
>replaced it, with a standard script??? Thank you in advance... I am very
>nervous about this one!!!!
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Sun Apr 26 1998 - 13:23:16 CDT