| recreating dbms_lock [message #61988] |
Wed, 16 June 2004 00:43  |
Edoardo Rossi
Messages: 1
Registered: June 2004
|
Junior Member |
|
|
I have a Oracle 9i and workflow 2.6 standalone.
When I execute wfbkg.sql, for execute the background Engine, I receive an error for DBMS_LOCK.
I have to execute the dbmslock.sql, for creating the package, but in the procedure's view, there isn't the body package for DBMS_LOCK.
how can I do?
thanks for all
|
|
|
|
| Re: recreating dbms_lock [message #61992 is a reply to message #61988] |
Wed, 16 June 2004 04:26  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
The body is wrapped (encrypted, so the source isn't visible). The creation script for the body will most probably be a file with .PLB excension. Most dbms_xxxxx packages are created through the CATPROC.SQL script if I'm not mistaken.
Look for a plb file containing the text "create or replace package body dbms_lock wrapped". That's the creation script for the body. Or, run CATPROC.SQL itself.
MHE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
