Re: Complie Oracle Stored Procedures

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: 21 Sep 2006 00:24:09 -0700
Message-ID: <1158823449.880012.93390_at_m73g2000cwd.googlegroups.com>


frank.van.bortel_at_gmail.com wrote:
> 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?).

[Quoted] [Quoted] At least in 9i there is dbms_utitlity.compile_schema. It can compile only one schema in one call, but this shouldn't be a big problem.

Gints Plivna
http://www.gplivna.eu Received on Thu Sep 21 2006 - 09:24:09 CEST

Original text of this message