Reference Manual
CHAPTER 9. SQL Statements
To replace a procedure with a modified version. You must include the entire new procedure in the ALTER PROCEDURE statement, and reassign user permissions on the procedure.
Also, to enable and disable a procedure for replication with Sybase Replication Server.
ALTER PROCEDURE [ owner.]procedure-name ( [ parameter , ... ] )
... [ RESULT ( result-column , ... ) ]
... [ ON EXCEPTION RESUME ]
... compound-statement
ALTER PROCEDURE [ owner.]procedure-name
... REPLICATE { ON | OFF }
parameter:
parameter_mode parameter-name data-type
... [ DEFAULT expression ] | SQLCODE | SQLSTATE
parameter_mode:
IN | OUT | INOUT
result-column:
column-name data-type
Must be the owner of the procedure or be DBA.
Automatic commit.
Syntax 1 The ALTER PROCEDURE statement is identical in syntax to the CREATE PROCEDURE statement except for the first word. The ALTER PROCEDURE statement replaces the entire contents of the CREATE PROCEDURE statement with the contents of the ALTER PROCEDURE statement. Existing permissions on the procedure are maintained, and do not have to be reassigned. If a DROP PROCEDURE and CREATE PROCEDURE were carried out, execute permissions would have to be reassigned.
Syntax 2 If a procedure is to be replicated to other sites, you must set REPLICATE ON for the procedure.
Syntax 2 of the ALTER PROCEDURE statement has the same effect as the sp_setreplicate or sp_setrepproc 'table' Adaptive Server Enterprise system procedures.
You cannot combine Syntax 2 with Syntax 1.
SQL/92 Vendor extension
Sybase Not supported by Adaptive Server Enterprise.