Re: trigger calling a procedure

[Rick Hillegas]

On 10/21/12 11:45 PM, Thomas Hill wrote:
CREATE TRIGGER "TR_XY"
   AFTER INSERT
   ON "TBL_XY"
   FOR EACH ROW
   CALL PROCEDURE "SP_xy"('xyz', 0);
Hi Thomas,
That's almost correct. If you remove the keyword PROCEDURE from the 
triggered statement, then it will be a valid SQL statement. The 
following would work:

CREATE TRIGGER "TR_XY"
  AFTER INSERT
  ON "TBL_XY"
  FOR EACH ROW
  CALL "SP_xy"('xyz', 0);

Hope this helps,
-Rick