SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rename a Procedure/Function. How?

484123Oct 6 2006 — edited Oct 6 2006

Hi folks!

what is the statement to rename a procedure whether it is a stand-alone or a packaged one?

I used

ALTER PROCEDURE <existing_procedure_name> RENAME TO <new_procedure_name>;

This statement is throwing some internal error message.

Your favour'll be deeply appreciated.

Thanks,
PCZ.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 3 2006

Added on Oct 6 2006

4 comments

1,996 views