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

In article <337861D3.2687_at_csc.com>,

        Bob Yeh <tyeh_at_csc.com> writes:
>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

ALTER PROCEDURE [schema_name.]procedure_name COMPILE;

or if its part of a package ...

ALTER PACKAGE [schema_name.]package_name COMPILE [BODY | PACKAGE];

This is what is needed after a procedure or package has become invalid (per the 'STATUS' in DBA_OBJECTS) becuase a referenced object has become invalid temporarily.

Bill

--