Skip to Content
0
Former Member
Feb 15, 2016 at 06:52 AM

How to use PAL in a trigger

25 Views

Hi everyone,

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

BEGIN

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;

END;

.......

When I run it, the error is : SAP DBTech JDBC: [7]: 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!