Re: Complie Oracle Stored Procedures
From: <frank.van.bortel_at_gmail.com>
Date: 20 Sep 2006 00:50:10 -0700
Message-ID: <1158738610.033660.230830_at_h48g2000cwc.googlegroups.com>
Date: 20 Sep 2006 00:50:10 -0700
Message-ID: <1158738610.033660.230830_at_h48g2000cwc.googlegroups.com>
Narmadha M schreef:
> I use 9 Schemas names sgsmain1 to sgsmain9.All the Database schemas has
> same oracle procedure.If i change a procedure in one schema i have to
> explicitly compile to all other schemas.is there any component that
> gets the schemas and compile to to all.
Strange setup - why not use one schema to hold the code, and grant the others execute rights?
Anyway - you have dependencies between the objects - are these packaged
procedures? Do not alter/recompile the package specification if you
can avoid it.
If you cannot avoid it - check utl_recomp
( if you're on 10G - why did you not post your version?).
Received on Wed Sep 20 2006 - 09:50:10 CEST