Re: compiler for PL/SQL?

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
Received on Thu Mar 18 1999 - 00:19:36 CST