Re: [PL/SQL] Replacing single procedure in a package?
From: Tim X <timx_at_spamto.devnul.com>
Date: 13 Jan 2003 20:58:15 +1100
Message-ID: <87znq574nc.fsf_at_tiger.rapttech.com.au>
Date: 13 Jan 2003 20:58:15 +1100
Message-ID: <87znq574nc.fsf_at_tiger.rapttech.com.au>
>>>>> "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!Received on Mon Jan 13 2003 - 10:58:15 CET