Hi Experts,

I am creating a XSODATA services file, where in i am using stored procedure(SQL Script) for updating the entries back in the HANA Custom table.

say for eg: "TEST" is my SCHEMA and "PROCEDURE" is my stored procedure.

XSODATA service file:

service namespace "Test.services" {

"TEST"."TABLE" as "mytable"

create using "TEST"."PROCEDURE";

}

When i'm using a procedure in xsodata services, getting the syntax error like below

Syntax error at line: 3, column:14.

Hence, i've tried creating a script view procedure under a test package with input & output parameters. I'm calling this procedure in my xsodata service file and getting this error saying "Invalid procedure or parameter list in procedure".

XSODATA service file:

service namespace "Test.Services"{

"TEST"."TABLE" as "mytable"

create using "TEST::PROCEDURE";

}

I am doing it for the first time, can you guys revert back with the solution.

I am confused of using the SQL script based procedure & hddbprocedure. which one i should use for this XSODATA services and what are the differences between these two types of procedures..!!