Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> procedure state has changed
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.
-- Syltrem http://pages.infinit.net/syltrem (OpenVMS related web site - en français) To reply to myself directly, remove zulu from my addressReceived on Thu Aug 29 2002 - 13:31:01 CDT
![]() |
![]() |