Skip to Content
avatar image
Former Member

How to Call procedure in trigger?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers