Thanks, that works. I've now got the Firebird bible open to page 613,
which has an example.

-----Original Message-----
From: Ivan Prenosil [mailto:Ivan.Prenosil@...]
Sent: Wednesday, December 29, 2004 2:38 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] How to call stored procedure from
trigger


The syntax is
EXECUTE PROCEDURE proc_name [var [, var ...]] [RETURNING_VALUES var [,
var ...]]

Ivan
http://www.volny.cz/iprenosil/interbase/

----- Original Message -----
From: "Rick DeBay" <rdebay@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, December 29, 2004 8:21 PM
Subject: [firebird-support] How to call stored procedure from trigger


>
> How do I correct the following trigger? It's complaining about the
> EXECUTE PROCEDURE part.
>
> DECLARE VARIABLE PO_ID BIGINT;
> DECLARE VARIABLE INV_ID BIGINT;
> begin
> /* create new/find existing PO and invoice */
> PO_ID = EXECUTE PROCEDURE P_CREATE_PO(NEW.PO, NEW.DIST_CTR,
> NEW.NABPNUM, NEW.GRANTEE, NEW.SUBMITTED);
> INV_ID = EXECUTE PROCEDURE P_CREATE_INVOICE(NEW.PO, NEW.INVOICE);
>
> /* create order-item record */
> INSERT INTO ORDER_ITEM(PURCH_ORDER, NDC, QTY, INVOICE, DIST_CTR,
> STATUS, STATUS_CHNG)
> VALUES (:PO_ID, COALESCE(NEW.NDC_SUB, NEW.NDC),
> COALESCE(NEW.QTY_SHIP_SUB, NEW.QTY_SHIPPED), :PO_ID, NEW.DIST_CTR,
'O',
> NEW.SUBMITTED);
> end
>
> Rick DeBay
> Senior Software Developer
> RxStrategies.net





Yahoo! Groups Links