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 f
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 ar
Hi all,
Our app is written using pl/sql's packages. When I
tried to display one form and it runs forever. So I
closed the form, and changed the sql in the package
that generates the form, and recompiled the pkg, and
the recompiling hangs. I checked the database, there
is no locking there. What s