Thread: 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.

You need to recompile the entire body part of the package.

Use This commands

ALTER PACKAGE emp_test
COMPILE PACKAGE;

For compile package body use this

ALTER PACKAGE scott.emp_test
COMPILE BODY;

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--

Originally Posted by ssvhari

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.

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 create or replace before package body
and recompile package body

Thank u for your quick response.
Keep sending useful answers.

Thanks & Regards,
--suresh--