Thats the whole problem. I already have an existing procedure which I just want to rename. I cannot drop it and recreate it with a different name. Is there a way to do this without dropping it and re-creating it again?

Actually my goal is to check whether the procedure is used by a certain command button on a front end app. Would tracing the session help me accomplish that?