Re: How to compile store procedure without replacing the old one

sure

alter package <schema.package> compile;
alter package <schema.package> compile body;

'alter' also works with procedures and views

Cheers,

Brian Murphy

Bob Yeh <tyeh_at_csc.com> wrote in article <337861D3.2687_at_csc.com>...
> Hi,
>
> I have been using sql*plus to compile my stored procedure by issuing:
> "create or replcae ..."
>
> Is ther a way to compile the source code without replacing the existing
> code?
>
> Thanks.
> Bob
>
Received on Tue May 13 1997 - 00:00:00 CDT