on 2024 Sep 26 4:17 PM
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
Request clarification before answering.
User | Count |
---|---|
30 | |
21 | |
16 | |
8 | |
7 | |
7 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.