cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Call stored HANA procedure with table type parameters from NodeJS on XSA

mikolaj_k
Explorer
0 Kudos
168

 

 

PROCEDURE "xsa.procedures::SAVE_AAA" (
    IN zzz "xsa.tabletypes::ZzzTableType",
    IN yyy "xsa.tabletypes::YyyTableType")
LANGUAGE SQLSCRIPT
SQL SECURITY INVOKER
AS
BEGIN
  
    CALL "xsa.procedures::InsertIntoZzz"(:zzz);
    CALL "xsa.procedures::InsertIntoYyy"(:yyy);
	    
END;

 

 

Hello,

Is it possible to call stored HANA procedure with tabletype parameters from NodeJS on XSA?
I have a procedure with tabletype parameters. Trying to call it using @ash_G/hdbext and passing arrays for zzz and yyy with objects with fields that exactly are in db tables but still getting error:

 

 

{
    "error": "Table parameter ZZZ is expected to be an array of objects or an object with \"table\" (mandatory) and \"schema\" (optional) properties"
}

 

 

Need some help with how to call it properly.

 

Thanks in advance,

Mikolaj 

Accepted Solutions (0)

Answers (0)