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

Member Avatar for 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.

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

Member Avatar for 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.