Re: SP hangs while recompiling. Is it Oracle BUG or just a FEATURE ?

Sergei Didur wrote:
>
> We use Oracle package, that contains about 20 SP.
> Most of SPs refer to 8 different packages, each of them refers to 1 table.
>
> (Main Pakage SP) - call -> (8 support package SP) - process -> (1 table per
> SP)
 [snip]
> So my assumption, that Oracle can't recompile package when any of its SP is
> in use.
>
> Does anybody have any similar expirience ?
> Is it a Oracle BUG or just a FEATURE ?
>
> We use Oracle 7.3.2 on HP UNIX machine.
> --
> Sergei Didur
> Systems Analyst
Yes. The example I had was a daemon and a procedure that called the daemon both of which resided within the same package. The daemon was run from one sqlplus session and the caling program from the other.

If I attempted to recompile the package whilst the daemon was running the SQLPLUS session in which I was trying to recompile would lock up. If I then killed the daemon the compilation would take place and the session would unfreeze.

Quite clearly Oracle locks a package when it is in use which after all makes some sense as the effects of updating a package whilst it were in use could never be determined.

Hope this helps

        Steve Received on Tue Jan 13 1998 - 00:00:00 CET