on 06-16-2017 3:18 PM
The scenario is, I have thousands of rows to be inserted into HANA DB.
What I have been trying is, I have created a function in XSJS and there I have parsed the data in the form of JSON.
var content = JSON.parse($.request.body.asString());
Now I pass this data to the Stored Procedure. and my Stored procedure accepts Table_Type as INPUT PARAMETER (IN).
when I do
var result = query(content);
(query : where I call the function, using ("sap.hana.xs.libs.dbutils", "procedures"))
I receive response - {"proc_param":"IT_CONTAINER"}
and when I do - var result = query(1,content)
I get-
{"argname":"IT_CONTAINER","argposition":0,"procedurename":"ADD_CONTAINERS_TEST","msg":"Table-value expected, found scalar"}
What I am doing wrong?
Is this the correct way to achieve what I am trying to do?
Please suggest if there is any other way to achieve the same.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.