Re: CREATE PROCEDURE in a package

In article <3d070d0b.5030433_at_news.btx.dtag.de>, swo-rhi_at_freenet.de says...
>
>Is there a way to create or replace a single procedure in a package
>instead of create or replace the whole package?
>
>Thanks, Rainer

No and since the code is always:

create or replace package body
as

 procedure p1
 is
   ..

 procedure p2
 is
   ....

end;

(eg: a single source code file, not N files for each individual procedure), it would not make sense or make anything more performant. The same amount of work would need be done to compile. (eg: p2 is possibly dependent on p1, recompiling p1 mandates p2 would need be recompiled as well)

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp