Procedure (Part of package) to be modified
Hi,
I want to modify the procedure which exists in package using SQL Plus.
But I should not touch entire package. I want to modify the particular part of procedure which is placed in package.
PS : In TOAD, we can directly change the script and compile using the option which available in TOAT. But I want to make it in "SQL Plus".
Kindly guide me on this.
Re: Procedure (Part of package) to be modified
You need to recompile the entire body part of the package.
Re: Procedure (Part of package) to be modified
Use This commands
ALTER PACKAGE emp_test
COMPILE PACKAGE;
For compile package body use this
ALTER PACKAGE scott.emp_test
COMPILE BODY;
Re: Procedure (Part of package) to be modified
Hi,
I think the question was asked for how to change the procedure in the package in sql*plus.
Sireesha if you give answer to change the procedure name or arguments without editing ,i.e by using alter command i would be very happy.
thanks
--suresh--
Re: Procedure (Part of package) to be modified
[QUOTE=ssvhari;25056]Hi,
I want to modify the procedure which exists in package using SQL Plus.
But I should not touch entire package. I want to modify the particular part of procedure which is placed in package.
PS : In TOAD, we can directly change the script and compile using the option which available in TOAT. But I want to make it in "SQL Plus".
Kindly guide me on this.[/QUOTE]
set feedback off
select text from user_source where name='package_name' AND TYPE='PACKAGE BODY'
spool c:\package_name
sql > /
spool off
in c:\package_name do necessary modification and add [B]create or replace [/B]before package body
and recompile package body
Re: Procedure (Part of package) to be modified
Thank u for your quick response.
Keep sending useful answers.
Thanks & Regards,
--suresh--