Fórum Procedure Não compila... #58293

CREATE PROCEDURE CHECAFERIADOS (
    wfilial integer,
    wdi date,
    wdf date)
returns (
    wdias integer)
as
begin
  SELECT Cod_Filial, Data FROM FERIADOS
  WHERE feriados.data BETWEEN :wdi AND :wdf and feriados.cod_filial =:wfilial
  into wfilial, :wdf;
  suspend;
end

SET TERM ^ ;

ALTER PROCEDURE CHECAFERIADOS (
    wfilial integer,
    wdi date,
    wdf date)
returns (
    wdias integer)
as
begin
  SELECT count(*) FROM FERIADOS
  WHERE feriados.data BETWEEN :wdi AND :wdf and feriados.cod_filial =:wfilial
  into :wdias;
  suspend;
end
^

SET TERM ; ^