CODEWITHSUNDEEP
oracle-databaseplsqlpackage
tricky12312
tricky12312

Reputation: 39

What happens to Executing Procedure if I Recompile Package Body on a different Procedure in the Same Package

If I have 1 Package with 2 procedures (A & B) what would happen to package A if it was executing and I needed to edit procedure B and recompile the overall package body.

Would A error due to the recompiling of the package or would it still fire off?

Many Thanks

Upvotes: 2

Views: 291

Answers (2)

Virgil Ionescu
Virgil Ionescu

Reputation: 337

You cannot compile package or package body if the procedure A is working because you will get acquire nowait timeout until A finishes.

Upvotes: 5

Littlefoot
Littlefoot

Reputation: 142720

If the procedure is being executed, compilation will fail (actually, it'll wait until the package is released, i.e. nobody uses it).

Upvotes: 1

Related Questions