on 02-15-2016 6:52 AM
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.