Hi Experts,
When the xsodata with procedure is created, the following error is occurred.
What action should do to solve this? Please.
1) Create table which named "MY_TABLE".
CREATE COLUMN TABLE "TEST"."MY_TABLE"(
"EMP_ID" CHAR(10) CS_FIXEDSTRING NOT NULL,
"EMP_NAME" VARCHAR(50) CS_FIXEDSTRING NOT NULL,
"DEPARTMENT" VARCHAR(50),
PRIMARY KEY ( "EMP_ID" ) );
2) Create the .hdbprocedure using hana development workbench.
PROCEDURE "TEST"."demo.test01::MyTable" (
IN NAME STRING,
OUT resultFlg INT )
LANGUAGE SQLSCRIPT
SQL SECURITY INVOKER
--DEFAULT SCHEMA <default_schema_name>
AS
BEGIN
/************************************* Write your procedure logic *************************************/
delete from "TEST"."MY_TABLE" where NAME = :NAME;
select count(*) into resultFlg from "TEST"."MY_TABLE" where NAME = :NAME;
END
3). Create the xsodata using the created procedure.
service {
"TEST"."MY_TABLE" as "MyTable"
delete using "demo.test01::MyTable";
}
As a result, cannot activate the xsodata successfully. The following error is occurred.
・Invalid parameter type in signature of procedure "demo.test01::MyTable". Only table types are allowed.
Best Regards,
Thiri