Calling procedure generated with HCP_AFL_WRAPPER_GENERATOR in XSJS

[Former Member]

I have a problem with running a generated PAL procedure on HCP Cloud edition. I used wrapper, HCP_AFL_WRAPPER_GENERATOR, and I am able to run it using SQL query

CALL _SYS_AFL.NEO_62G0J0********_PAL_ANOMALY_DETECTION_PROC

I am familiar with the following documentation: SAP HANA Cloud Platform

I try to run procedure using XSJS code.

    XSProc.setTempSchema("NEO_62G0*****");


    var procedure = XSProc.procedureOfSchema("_SYS_AFL", "NEO_62G0J******_PAL_ANOMALY_DETECTION_PROC");
    var data = getConvertedData(inputData);


    return procedure(data);

and i got an error

Failed to execute action: InternalError: dberror(Connection.prepareCall): 1281 - wrong number or types of parameters in call: P1 is not bound: line 1 col 17 (at pos 16)

The same code works on ordinary HANA instance, so data model and JS implementation i assume to be ok. Do you know where the problem might be?

[achab]

Hi Piotr, is your question answered?

Kind regards

Antoine

[SergioG_TX]

seems like you are missing some input parameter P1 ? how are you passing the input params?

[Former Member]

In XSJS code I pass parameter in line 4. Funny thing, it works on our Hana system, but does not work on Cloud edition. I thing that another wrapper that is used on Cloud service may alter calling procedure, but I don't have a clue, how it should look like.

[SergioG_TX]

here is an example, how I did it on my scenario calling a stored proc from XSJS