CREATE OR ALTER PROCEDURE

`CREATE OR ALTER PROCEDURE` Example

Creating or altering the GET_EMP_PROJ procedure.

CREATE OR ALTER PROCEDURE GET_EMP_PROJ (
    EMP_NO SMALLINT)
RETURNS (
    PROJ_ID VARCHAR(20))
AS
BEGIN
  FOR SELECT
      PROJ_ID
    FROM
      EMPLOYEE_PROJECT
    WHERE
      EMP_NO = :emp_no
    INTO :proj_id
  DO
    SUSPEND;
END

`DROP PROCEDURE`

Drops a stored procedure

Available in

DSQL, ESQL

Syntax

DROP PROCEDURE procname

Table 1. `DROP PROCEDURE` Statement Parameter
Parameter	Description
procname	Name of an existing stored procedure

The DROP PROCEDURE statement deletes an existing stored procedure.If the stored procedure has any dependencies, the attempt to delete it will fail and raise an error.

CREATE OR ALTER PROCEDURE

CREATE OR ALTER PROCEDURE Example

DROP PROCEDURE

`CREATE OR ALTER PROCEDURE` Example

`DROP PROCEDURE`