Paul,
>From what I remember, if a package has been marked "invalid" and a user
tries to execute it, it DOES get re-compiled at that time, but does not get
executed. So the FIRST call to an invalid Package changes it's state to
valid. The Second call will actually execute the package.
The only
On Thu, Jun 28, 2001 at 10:56:23AM -0800, Troiano, Paul (CAP, GEFA) wrote:
>
> We have one package A that refers to package B. If package B's body and
> specification are both recompiled by user 1, package A is correctly marked
> as invalid. Another user, user 2, then attempts to execute package
Hi Paul,
I agree completely with you and feel your pain.
I have a workaround though, if the changes made to your package does not
affect the specification(i.e no new parameters, no new functions/procedures)
really, for changes only to the package body,
You can do a ALTER PACKAGE package_name COM
Thanks Lisa and others,
The dbms_utility.compile_schema will work. It is a bit annoying though as
this involves six schemas and hundreds of packages to be recompiled.
Fortunatly I do keep control and there are no circular dependencies in the
packages. I am sending out an order of dependency amon
ional
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Thursday, June 28, 2001 4:03
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Invalid packages not being recompiled by Oracle
later versions of oracle
$ORACLE_HOME/rdbms/admin/utlrp.sql
You may run a script in cron to check invalids and recompile them. It may
run once or twice in a day...This problem pertains to custom code...
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 28 Jun 2001 11:50:27 -0800
Are you
Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Thursday, June 28, 2001
3:20 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Invalid packages not being recompiled by
Oracle
HI Paul,
By chance can you use
dbms_utility.compile_Schema after
for c1_rec in c1 loop
dbms_output.put_line(c1_rec.out_line); end
loop; dbms_output.put_line('exit');end;/spool
off@compile
Tom Mercadante Oracle Certified Professional
-Original Message-From: Koivu, Lisa
[mailto:[EMAIL PROTECTED]]Sent: Thursday, June 28, 2001
3:20 PMTo
Title: RE: Invalid packages not being recompiled by Oracle
Paul,
Lisa
has the correct answer - you must recompile all dependent items.
This
behavior has been standard since the beginning of PL/SQL.
Actually, if your application could be changed to
capture the error, and just call the
Are you talking about an auto-recompile that happens when a user tries to
access a package that is invalid ?? Basically, just like views do ???
I have wanted that for a long time ! Every time we modify one package we
always have to go back and do an entire recompile on our system. There are
u
Title: RE: Invalid packages not being recompiled by Oracle
HI Paul,
By chance can you use dbms_utility.compile_Schema after recompiling? Are you using it already? I know it doesn't answer your quesiton but this package is suppossed to follow the dependencies, no matter how odd the
Does the owner of the package have a private database link that is utilized
by the package? The only person that can compile such a package it the
owner.
--Michael
-Original Message-
Sent: Thursday, June 28, 2001 2:56 PM
To: Multiple recipients of list ORACLE-L
We have one package A
12 matches
Mail list logo