The Firebird 5.0 Language Reference | RECREATE PROCEDURE | RECREATE PROCEDURE Example

TRIGGERFUNCTION

`RECREATE PROCEDURE` Example

Creating the new GET_EMP_PROJ stored procedure or recreating the existing GET_EMP_PROJ stored procedure.

RECREATE 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

See also

[fblangref50-ddl-proc-create], [fblangref50-ddl-proc-drop], [fblangref50-ddl-proc-crtoralter]