Re: PL/SQL procedures and packages

Hi,
[Quoted] [Quoted] That was good advice from Stevens but I am sure that won't help u with the work.
The PL/SQL compiled version stays in the memory when u compile the same. Then even if u delete u'r source file the compiled version will stay put.
So enjoy.
Always use CREATE OR REPLACE ...when u create procedures..it drops the compiled version & re-creates the procedure.

Avinash

Amoda Kulkarni wrote:
>
> Hi All,
> How do I make PL/SQL procedures and functions stay in memory?
>
> Thanks in Advance
> Amod
  Received on Mon Jan 05 1998 - 00:00:00 CET