🚀 go-pugleaf

"Roy" <butcherr@candw.lc> wrote in message 
news:46be396c@newsgroups.borland.com...
> 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
>
> The error message is as follows

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 6, char 40.
;.

>
>