Skip to Content
0

How to Call procedure in trigger?

Feb 09 at 01:43 AM

30

avatar image
Former Member

I want to create a row in Table2 on insert of a row in Table1, before inserting in to table2 i need to check some conditions and create row data of table2 based on the values of table1. I want to create a before trigger on insert of table1 and send row data as input to procedure and do calculations and create row data of table 2. am trying it on SAP Hana.

CREATE TRIGGER "schema"."CREATE_ALERTS_TRIGGER_TEST" BEFORE INSERT ON "schema"."package.table::master.table1" REFERENCING NEW ROW NEWIOTROW FOR EACH ROW
BEGIN
CALL "pacalge.Procedures::createAlertsTest"(:NEWIOTROW,var_out) ;
END

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers