How to use PAL in a trigger

[Former Member]

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!

[achab]

Hi,

Looping to help as this is a PAL-related question.

Thanks in advance,

Antoine Chabert