Re: procedure state has changed

On Thu, 29 Aug 2002 14:31:01 -0400, "Syltrem" <syltremzulu_at_videotron.ca> wrote:

>Hi
>
>Oracle 816 and OpenVMS 7.2-1
>
>I remember seeing a conversation on this ng about having separate files for
>the package header and the package body.
>
>I thinks the discussion was about avoiding the message "procedure (or
>package?) state has changed" (can't remember the exact message right now).
>
>Say I only modify some logic in one procedure in the body, is it a good
>thing that I only recompile the body, or it really does not matter? I know
>on my web application if I change one procedure and re-execute (@ command)
>the one file that contains both the package header and body while a client
>is connected to the web site, the client will get an error at the next call
>for a procedure in this package.
>
>I searched the ng archive and found nothing, and also Metalink is not
>responding today (for me anyway).
>
>Thanks for your thoughts.

Recompiling the body would only invalidate the package body. Recompiling the package would have effect on all procedures and packages calling the package.

and of course
ALTER PACKAGE <package name> COMPILE BODY;

probably doesn't exist without a reason.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Aug 29 2002 - 14:15:37 CDT