You can also check v$access and v$session for any active sessions accessing
that package.
Jay Miller
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 18, 2003 5:34 PM
To: Multiple recipients of list ORACLE-L
This was discussed on 31-October and look in the archives
This was discussed on 31-October and look in the archives for the details, but:
What did you check for locking - if dba_locks or standard utllockt.sql then it won't
show.
You could use Steve Adam's script Executing_packages.sql at
http://www.ixora.com.au/scripts/misc.htm to see what packages
