Skip to Content

XSODATA with .hdbprocedure in SAP HANA Web Development Workbench

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jul 22, 2020 at 10:38 AM

    The interface of your procedure does not match the requirements for an SQLScript procedure exit.

    It can only have two parameters:

    • One input parameter typed to the entity.
    • One output error parameter.

    For details please check the documentation here.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.