HANA PAL PROCEDURE CALL ERROR
Hi Experts ,
I am following step by step guide as mentioned here to use PAL libraries :HANA Academy - Key Concepts of the Predictive Analysis Library - YouTube
I have successfully created
3.Created a procedure using AFL_WRAPPER_GENERATOR and the signature table for a SINGLESMOOTH function
4.Now to populate the results into the results table i am calling the procedure
call "_SYS_AFL"."PAL_TS_S_1"(TS_DATA,TS_PARAMS,TS_RESULTS); //All are tables
But , it is throwing the error
Could not execute 'call "_SYS_AFL"."PAL_TS_S_1"(TS_DATA,TS_PARAMS,PAL_T_TS_RESULTS)'
SAP DBTech JDBC: : wrong number or types of parameters in call: Physical table is not allowed in OUT table variable position: PAL_T_TS_RESULTS: line 1 col 48 (at pos 47)
Any Idea what is the actual peoblem??
Florian Pfeffer replied
then please check if you have all necessary privileges/roles assigned (e.g. roles described in chapter 2.3 of http://help.sap.com/hana/SAP_HANA_Predictive_Analysis_Library_PAL_en.pdf ).