Trigger action lists and host variable lists.
Posted in 1999
PAUL HOWARD — — source: Informix-list mailing list archive (1991-1998)
Using IDS 7.22 on AIX 4.2
I have a trigger as follows and this should work as per SQL reference
manual.
create trigger TRIGGERA insert on shipto referencing new as pst
for each row
( execute procedure get_code(pst.city, pst.county, pst.state,
pst.post_code, pst.cust_code, pst.ship_to_code)
into shipto.code, shipto.county );
I get the following error:
731: Invalid use of column reference in trigger body.
I imagine this error is because both trigger action lists and host
variable lists use commas as separators.
Is there any way to execute a procedure that returns two values from a
trigger as the manual suggests?