Re: [PL/SQL] Replacing single procedure in a package?

>>>>> "Bogien" == Bogien <bogien_at_xcom.pl> writes:

 Bogien> Hello, I want to replace a single procedure in a package. Is  Bogien> it necessary to rewrite/replace the whole package?

 Bogien> I've tried: "create or replace procedure
 Bogien> package_name.procedure_name" ...unfortunately, this did not
 Bogien> work.

 Bogien> Thanks!

Yes, you will need to replace the whole package. If you don't have the source in a file, you can get it out of the database, make the changes you want to make and then re-load it.

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!