UDRs That EXECUTE PROCEDURE and EXECUTE FUNCTION Call

A Select trigger is activated by a UDR if the UDR contains a SELECT statement within its statement block and the UDR is called by an EXECUTE PROCEDURE or (for IDS triggers only) the EXECUTE FUNCTION statement. For example, assume that the user-defined procedure named my_rtn contains the following SELECT statement in its statement block:

SELECT col1 FROM tab1

Now suppose that the following statement invokes the my_rtn procedure:

EXECUTE PROCEDURE my_rtn()

This statement activates the Select trigger defined on column col1 of table tab1 when the SELECT statement within the statement block is executed.