​Getting 500 invalid colname-while calling a hana proc with 2 tabletypes as input parameter in xsjs

[former_member597564]

Getting 500 invalid column name : <columnnamexxxx> while calling a hana procedure with 2 tabletypes ...

stored procedure already return by using 2 tabletypes as input parameter. for ex: var qry = conn.prepareStatement("call \"\"(#localtabletype1,#localtabletype2,?)"); In localtabletype1(ID,Name,Location) and localtabletype2(DepartmentNo,DepartmentName,Designation,Salary). while calling the procedure (var qry = conn.prepareStatement("call \"\"(#localtabletype1,#localtabletype2,?)");)like this getting an error saying "500 Invalid column name:ID" in xsjs output. Kindly help me

[pfefferf]

As for nearly all your questions: Please add more details to your question and invest more time in describing what you are doing instead of posting such cryptic stuff. E.g. show your whole xsjs coding, show the procedures you are trying to call ...

Regards,
Florian