Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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
1.Table types
2.Signature Table
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: [1281]: 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??

Parameter table

Data Table

Tags:
Former Member
replied

Hi,

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 ).

Best Regards,

Florian

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question