I want to create a trigger in the hana database. When a new record is inserted into a table, a trigger will work and PAL is called to process the new inserted data.
CREATE TRIGGER "NEO_********"."TEST_TRIGGER" AFTER INSERT ON "NEO_********"."PREDICTION" FOR EACH ROW
call "_SYS_AFL"."NEO_********_PAL_SVM_PREDICT"(pre_trans,#PAL_CONTROL_TBL,PAL_SVM_MODELPART1_TBL,PAL_SVM_MODELPART2_TBL,PAL_SVM_PREDICTION_TBL) WITH OVERVIEW;
When I run it, the error is : SAP DBTech JDBC: : feature not supported: Only table variable is allowed in input parameter in a nested call
That is to say, I cannot use PAL in a trigger? How to solve it?
Thank you very much!