Question Re: SAP Cloud Application Programming: Procedure arguments in Technology Q&A

SAP Cloud Application Programming: Procedure arguments

robert_schmidt01 — Fri, 28 Aug 2020 16:51:37 GMT

Hi, I have a SAP Cloud Application that is calling procedures. All the procedures that do not have arguments are working well, but I cannot get the procedure with arguments to work. I have narrowed it down to the following lines in my node.js service file:

const ip = [{"PID": PID}, {"CENTERLAT": CENTERLAT}, {"CENTERLONG": CENTERLONG}, {"PTOL": PTOL}, {"ETOL": ETOL}, {"CURRLAT": CURRLAT}, {"CURRLONG": CURRLONG}, {"OPEN_CLOSE": OPEN_CLOSE}, {"LDATE": LDATE}, {"LTIME": LTIME}]     

const output = await dbConn.callProcedurePromisified(sp, ip)

The error that I am getting is:

    { code: -20007,
      message: 'Can not bind parameter(0).',
      sqlState: 'HY000' }
    [2020-08-28T16:30:32.649Z | ERROR | 1987505]: An error occurred during serialization of the entity collection.
    [2020-08-28T16:30:32.649Z | ERROR | 1987505]: Error stacktrace: SerializationError: An error occurred during serialization of the entity collection.

When I console.log ip, I get:

    [ { PID: 'ab9359f1-2b72-4a4b-abf2-0295c7913b51' },
      { CENTERLAT: 32.352521 },
      { CENTERLONG: -117.632423 },
      { PTOL: 3.999999 },
      { ETOL: 5 },
      { CURRLAT: 32.321456 },
      { CURRLONG: -117.090456 },
      { OPEN_CLOSE: 'C' },
      { LDATE: '12122059' },
      { LTIME: '121259' } ]

My Procedure definition is:

PROCEDURE "PointPathDistance" (IN PID NVarChar(36),
                               IN CENTERLAT Double,
                               IN CENTERLONG Double,
                               IN PTOL Double
                               IN ETOL Double,
                               IN CURRLAT Double,
                               IN CURRLONG Double,
                               IN OPEN_CLOSE NVarChar(1),
                               IN LDATE NVarChar (8),
                               IN LTIME NVarChar(8),
                               out result "GUARDIANANGEL_USERLOCATIONS")

Any ideas?

Thanks.

Re: SAP Cloud Application Programming: Procedure arguments

robert_schmidt01 — Fri, 28 Aug 2020 17:18:09 GMT

I was doing this:

const {PID, CENTERLAT, CENTERLONG, PTOL, ETOL, CURRLAT, CURRLONG, OPEN_CLOSE, LDATE, LTIME} = req.data


const ip = [{"PID": PID}, {"CENTERLAT": CENTERLAT}, {"CENTERLONG": CENTERLONG}, {"PTOL": PTOL}, {"ETOL": ETOL}, {"CURRLAT": CURRLAT}, {"CURRLONG": CURRLONG}, {"OPEN_CLOSE": OPEN_CLOSE}, {"LDATE": LDATE}, {"LTIME": LTIME}]


const output = await dbConn.callProcedurePromisified(sp, req.data)

Basically deconstructing req.data into a code array and passing it into the callProcedurePromisified function. Then, I thought why not just pass in req.data? as in the following:

const output = await dbConn.callProcedurePromisified(sp, req.data)

It works!!

Re: SAP Cloud Application Programming: Procedure arguments

devboy — Fri, 12 Aug 2022 11:25:03 GMT

How can I call stored procedure using event handler in node js .

I have tried but it can't works.

I have created a SP

PROCEDURE "stored_p"( IN ID NVARCHAR (50), IN title VARCHAR(50), IN stock NVARCHAR(50), IN Authors_ID NVARCHAR(50), OUT result "MY_BOOKSHOP_BOOKS"

)

LANGUAGE SQLSCRIPT SQL SECURITY INVOKER --DEFAULT SCHEMA <default_schema_name> AS

BEGIN

INSERT INTO "MY_BOOKSHOP_BOOKS" ("ID","TITLE","STOCK","AUTHORS_ID")VALUES (ID,title,stock,Authors_ID);result = select * from "MY_BOOKSHOP_BOOKS" where ID =:ID;JS CODE:this.on('addBook', async req=>{ try{ const {ID,title,stock,Authors_ID} = req.data
const ip = [{"ID": ID},{"title":title},{"stock":stock},{"Authors_ID":Authors_ID}]; const db = await cds.connect.to('db') const dbClass=require("sap-hdbext-promisfied") let dbConn=new dbClass(await dbClass.createConnection(db.options.credentials)) const hdbext=require("@sap/hdbext") const sp=await dbConn.loadProcedurePromisified(hdbext,null,'stored_p') const output=await dbConn.callProcedurePromisified(sp,req.data) console.log(output.results) return output.results }catch(error){ console.error(error) return {} }
})This is cds view action addBook () returns array of Books;
But i get this error{ "@odata.context": "$metadata#Books", "value": [ {} ]}Is there any solution??