Hi,

We are facing problem while calling procedure multiple times from Trigger.
Procedure inserts a record in a single table. Following error is encountered
:

SQL0723N An error occurred in a triggered SQL statement in trigger
"DB2ADMIN.ZZZ". Information returned for the error includes SQLCODE "-751",
SQLSTATE " " and message tokens "DB2ADMIN.PROC|SQL050929172036500".
SQLSTATE=09000

Please suggest a way to call a procedure multple times to insert row(s).

CREATE PROCEDURE proc ( )
BEGIN
insert into temp2(id)values(22);
END

CREATE TRIGGER DB2ADMIN.LOG_AU AFTER UPDATE OF ID, CDATE ON DB2ADMIN.TEMP1
FOR EACH ROW MODE DB2SQL BEGIN ATOMIC
call proc();
call proc();
END;

Regards
Amit Singal



DB2 & UDB email list listserv db2-l LazyDBA home page