Skip to Content
0
Jul 22, 2020 at 06:15 AM

XSODATA with .hdbprocedure in SAP HANA Web Development Workbench

103 Views

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