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

From: Frances Edelstein <fran_at_rbsbooks.com>
Date: 1997/05/13
Message-ID: <MPG.de253508267bd20989688@snews.zippo.com>#1/1

[This followup was posted to comp.databases.oracle.misc and a copy was sent to the cited author.]

In article <337861D3.2687_at_csc.com>, tyeh_at_csc.com says...
> 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
>

You can use use the alter package, alter procedure, or alter function commands to do this. If you want to compile everything, use the dbms_utility.compile_schema procedure. To look at the package specification for this query the all_source table:

select text from all_source where name = 'DBMS_UTILITY' and type = 'PACKAGE' order by line.

Frances Edelstein
Relational Business Systems
Author of Learning Oracle Database Programming http://www.rbsbooks.com Received on Tue May 13 1997 - 00:00:00 CDT