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

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 Tue Apr 21 1998 - 00:00:00 CDT