Skip to Content
0
Former Member
Nov 20, 2015 at 04:02 PM

Consume Stored Procedures In HANA ODATA Services

1157 Views

Hi All,

I have created a stored procedure with 4 input and 4 output parameters as below,

PROCEDURE "BPS_SCHEMA"."AB_BPS::Final_SP"

( in in_flag varchar(1),

in in_carrid nvarchar(3),

in in_connid nvarchar(4),

in in_fldate nvarchar(8),

out out_spfli "BPS_SCHEMA"."SPFLI_TT",

out out_sflight "BPS_SCHEMA"."SFLIGHT_TT",

out out_sbook "BPS_SCHEMA"."SBOOK_TT",

out out_error_message nvarchar(500) )

LANGUAGE SQLSCRIPT

SQL SECURITY INVOKER

DEFAULT SCHEMA "BPS_SCHEMA"

READS SQL DATA AS

BEGIN

My Query ....

END;

Tried calling the above procedure in a Calc. View and use it in my service.

But, I am getting some error like "No measure defined in a reporting enabled view"

when I tried to activate the view .. Can we add tables as output parameters in views?

Could you please suggest me some way to achieve this?

Thanks in advance,

Arun.

Attachments

Capture.PNG (6.1 kB)