Renaming Stopred Procedures

[Yathini]

How to Rename stored procedures in PL/SQL
Is there any query for that?

[griswolf]

Apparently that isn't available yet in MySql, though there is a bug about it: http://bugs.mysql.com/bug.php?id=27793

EXEC sp_rename 'spGetAvgGrade', 'spNewAvgGrade';

You will receive the following warning, but the procedure will be renamed

Caution: Changing any part of an object name could break scripts and stored procedures.

Method II: drop and recreate the procedure.

[Yathini]

but it wont work in pl/sql i need query in pl/sql

create or replace procedure new_procedure_name
as
begin 

old_procedure_name; 

end;