Rename Stored Procedure Syntax
Hi All...
I am sitting with a situation where i need to Rename a stored Procedure and Not drop it. Reason for this is that i need it for a backup. I searched all over the web for a Example and all i can get is this darn "useless example"(for me)
ALTER {PROCEDURE | FUNCTION} sp_name [characteristic ...]
characteristic:
NAME newname
| SQL SECURITY {DEFINER | INVOKER}
| COMMENT string
found at
http://teaching-2.cs.uml.edu/MySQLdocs/MySQL_Manual/ALTER_PROCEDURE.html
In the first place this does not work for me it gives me an error.
can someone please just give me an example as to how to rename a Stored Procedure.
Subject
Written By
Posted
Rename Stored Procedure Syntax
August 04, 2009 04:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.