Re: compiler for PL/SQL?

The compiler is built in; the code is compiled when you 'execute' the create trigger|procedure|package| etc. statement. The errors you get back , if any, are from the compiler. A trigger|procedure|package| etc is also (re)compiled when any of its dependents change (ex. add a column to a tqabel ref'd by the code)

On Wed, 17 Mar 1999 15:03:51 +0100, frank <frank_at_mediaaktiv.de> 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
>

+-+-++-+-++-+-++-+-++-+-++-+-++-+-++-+-+ Lenfest Communications
West Chester, PA.

My opinions are not neccessarily those of my employer - but probably should be ! Received on Wed Mar 17 1999 - 08:59:47 CST