db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <rick.hille...@oracle.com>
Subject Re: trigger calling a procedure
Date Mon, 22 Oct 2012 12:37:18 GMT
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

Mime
View raw message