🚀 go-pugleaf

Hello,

I have this stored procedure. If I call it from IB Console like this SELECT 
* from NEW_PROCEDURE('8/1/2007') it works fine.

COMMIT WORK;
SET AUTODDL OFF;
SET TERM ^ ;

/* Stored procedures */

CREATE PROCEDURE "NEW_PROCEDURE"
(
  "IN_DATE" DATE
)
RETURNS
(
  "OUT_DATE" DATE,
  "OUT_MSC" VARCHAR(10),
  "OUT_TRAFFIC" FLOAT,
  "OUT_GROUP" INTEGER
)
AS
BEGIN EXIT; END ^


ALTER PROCEDURE "NEW_PROCEDURE"
(
  "IN_DATE" DATE
)
RETURNS
(
  "OUT_DATE" DATE,
  "OUT_MSC" VARCHAR(10),
  "OUT_TRAFFIC" FLOAT,
  "OUT_GROUP" INTEGER
)
AS
begin
For
 Select START_DATE,MSC_NAME, GROUP_, MAX(TRAFFIC) from SysGrpPerf where
 START_DATE = :IN_DATE GROUP BY START_DATE,MSC_NAME, GROUP_
 INTO : OUT_DATE,: OUT_MSC,:OUT_GROUP, :OUT_TRAFFIC
 DO
  INSERT INTO TMPTRANS
  (START_DATE,MSC,ROUTE_ID,TRAFFIC)
  values (:OUT_DATE, :OUT_MSC, :OUT_GROUP,:OUT_TRAFFIC);
 Suspend;
end
 ^

SET TERM ; ^
COMMIT WORK;
SET AUTODDL ON;

What I want to do is call it from a Trigger like this;


CREATE trigger call_tmp_procedure for sysgrpperf
active after insert position 0
AS
begin
if (NEW.STOP_TIME = '12:00 PM') then
SELECT * FROM NEW_PROCEDURE(CURRENT_DATE)
end

But the Trigger does not complile. I get an error when creating hte trigger.



Thanks for your help.


Roy