Alter Procedure

You are looking at an older version of the documentation. The latest version is found here.

Usage

ALTER PROCEDURE views.<procedurename> AS block

Syntax Rules

• The ALTER block should not include CREATE VIRTUAL PROCEDURE;
• Do not use VIRTUAL as in CREATE VIRTUAL PROCEDURE;
• The ALTER block may be prefixed with a cache hint for cached procedures;
• Parameters and return values will be used as given in the ALTER PROCEDURE command, so they may not be omitted if they should be kept.

Example

ALTER PROCEDURE views.dateaxis() returns (xdate date) as  
BEGIN
 SELECT current_date;
END;;