How to Rename stored procedures in PL/SQL
Is there any query for that?
Yathini 0 Newbie Poster
griswolf 304 Veteran Poster
Apparently that isn't available yet in MySql, though there is a bug about it: http://bugs.mysql.com/bug.php?id=27793
rajarajan2017
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 0 Newbie Poster
but it wont work in pl/sql i need query in pl/sql
rajarajan2017
create or replace procedure new_procedure_name
as
begin
old_procedure_name;
end; Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.