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

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)

When we call any main package SP from ProC program and in the same time invalidate
any of refered packages with DROP/CREATE table, all Oracle connections, that use this package hangs. CPU usage drops to 0.1 %. When we kill ProC programs all other calls complete successfully.

When we do the same, but call main package SP from SQL Plus - no problems.

When we invalidate package in the same way, but call any SP later - Oracle successfully recompile package and execute this SP.

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