User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

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.

Syntax

     ALTER PROCEDURE [ owner.]procedure-name ( [ parameter , ... ] )
          ...    [ RESULT ( result-column , ... ) ]
          ...    [ ON EXCEPTION RESUME ]
          ...    compound-statement

Parameters

     parameter:
               parameter_mode parameter-name data-type
          ...     [ DEFAULT expression ]
              | SQLCODE
              | SQLSTATE

     parameter_mode:
               IN
              | OUT
              | INOUT

     result-column:
              column-name data-type

Usage

Anywhere.

Permissions

Must be the owner of the procedure or be DBA.

Side effects

Automatic commit.

See also

• CREATE PROCEDURE statement

Description

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.