trigger & stored procedures
Hi all,
I'm strugeling with executing 2 stored procedure in a trigger.
for example:
create trigger trig1insert on products
referencing new as new
for each row(
execute procedure sp1()
execute procedure sp2()# 201: a syntax error has occured
);
Is it possible to call 2 stored procedures in a trigger?
thanks!
Yes, it is possible:
Syntax is:
create trigger trig1insert on products
referencing new as new
for each row(
execute procedure sp1(),
execute procedure sp2()
);
-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
DANNY DE KOSTER
Sent: Wednesday, May 25, 2011 3:19 PM
To: ids@iiug.org
Subject: trigger & stored procedures [23822]
Hi all,
I'm strugeling with executing 2 stored procedure in a trigger.
for example:
create trigger trig1insert on products
referencing new as new
for each row(
execute procedure sp1()
execute procedure sp2()# 201: a syntax error has occured
);
Is it possible to call 2 stored procedures in a trigger?
thanks!
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
Missing semi-colon between the procedure calls.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Wed, May 25, 2011 at 9:19 AM, DANNY DE KOSTER <ddk@fidelity-soft.be>wrote:
> Hi all,
> I'm strugeling with executing 2 stored procedure in a trigger.
> for example:
> create trigger trig1> insert on products
> referencing new as new
> for each row(
>
> execute procedure sp1()>
> execute procedure sp2()> # 201: a syntax error has occured
> );
>
> Is it possible to call 2 stored procedures in a trigger?
> thanks!
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--bcaec548a6dbc9b32204a419c4ff