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

Home -> Community -> Usenet -> c.d.o.misc -> Re: compiler for PL/SQL?

Re: compiler for PL/SQL?

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Thu, 18 Mar 1999 15:50:39 +0800
Message-ID: <36F0B04F.539C@bhp.com.au>


Andrew Babb wrote:
>
> Frank,
>
> The other thing to remember is that Triggers are compiled every time they
> are executed unlike PL/SQL Packages and Procedures. This is another reason
> for keeping Triggers small, and passing the real work into a Package or
> Procedure.
>
> Good Luck,
> Andrew
>
> frank wrote:
>
> > Hello everybody,
> >
> > I'd like to know if there is a compiler for PL/SQL scripts such as
> > stored Procedures or triggers.
> > In the documentation I read about a compiler, but I was not able to find
> > out how to use it. (Or is it used automatically when I create a trigger?
> > If so, it doesn't work well at all)
> > I'm using a NT System and Oracle 7.3.
> >
> > Thanks in advance
> > Frank

This is not the case from 7.3 upwards....

Issuing "alter trigger xxx compile" will store the p-code for triggers in the same way it did for procs etc...

HTH
--



Connor McDonald
BHP Information Technology
Perth, Western Australia
"Never wrestle a pig - you both get dirty and the pig likes it..." Received on Thu Mar 18 1999 - 01:50:39 CST

Original text of this message

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