How to recompile package without Invalidation
From: gatorade <Gatorade_at_free.fr>
Date: 4 May 2002 05:29:38 -0700
Message-ID: <f6a787b3.0205040429.5b7db3b8_at_posting.google.com>
What will happend if I recompile a package and at the same time, a user on our web-site is calling the package via a procedure.
My idea is to do something like this.
If I want to recompile the package A.
So I'm going to make a copy of it (called A2). Create a synomym A for the package A2. (impossible object already exists !!) Fix the bug on the package A.
Drop the synonym A.
Date: 4 May 2002 05:29:38 -0700
Message-ID: <f6a787b3.0205040429.5b7db3b8_at_posting.google.com>
QUESTION:
What will happend if I recompile a package and at the same time, a user on our web-site is calling the package via a procedure.
Fatal error on the site ?
How to avoid this ?
My idea is to do something like this.
If I want to recompile the package A.
So I'm going to make a copy of it (called A2). Create a synomym A for the package A2. (impossible object already exists !!) Fix the bug on the package A.
Drop the synonym A.
This doesn't work.
How can I make a switch between 2 packages
A and A2 with no impact for the site?
Thank you for your Help. Received on Sat May 04 2002 - 14:29:38 CEST