Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> procedure state has changed

procedure state has changed

From: Syltrem <syltremzulu_at_videotron.ca>
Date: Thu, 29 Aug 2002 14:31:01 -0400
Message-ID: <wLtb9.9609$H67.52161@tor-nn1.netcom.ca>


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 address
Received on Thu Aug 29 2002 - 13:31:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US