CREATE DOMAIN DOM$INTEGER AS
INTEGER;

CREATE OR ALTER PROCEDURE TEST_SP_PARAM (
    PARAM1 DOM$INTEGER)
AS
BEGIN
END

CREATE OR ALTER PROCEDURE TEST_SP_PARAM (
    PARAM1 DOM$INTEGER,
    PARAM2 DOM$INTEGER)
AS
BEGIN
END

SET SQL DIALECT 3;

SET AUTODDL ON;

/******************************************************************************/
/****            Altering stored procedures (with empty bodies)            ****/
/******************************************************************************/
SET TERM ^ ;

ALTER PROCEDURE TEST_SP_PARAM(
  PARAM1 /* DOM$INTEGER */ ,
  PARAM2 /* DOM$INTEGER */ )
AS
BEGIN
  EXIT;
END
^


/******************************************************************************/
/****                      Altering stored procedures                      ****/
/******************************************************************************/
ALTER PROCEDURE TEST_SP_PARAM(
  PARAM1 DOM$INTEGER,
  PARAM2 DOM$INTEGER)
AS
BEGIN
END
^


SET TERM ; ^