Call a Procedure from SAP XS Odata

[Former Member]

Hi,

I crated an XS OData Servcie like This.

service namespace "workshop.services" { 

       "Test_Schema"."Test" as "Test"; 

}

But I want to Call Stored Procedure from this.

Please help me.

[sreehari_vpillai]

As Vivek mentioned, you can not use procedures in xsodata for GET operation. But, for create , you can check the 'CREATE USING' option available. Otherwise, create the procedure with result view, and use the result view to expose as odata.

Sreehari

[Former Member]

Thanks

I want to do Update using in the XsOdata.

But the update procedure has single input parameter.

So I Cannot pass type or table.

Please help me.

[vivekbhoj]

Hi,

You can't call procedure directly in odata service.

You can call the procedure inside a scripted calculation view and then call this view inside odata service.

Regards,

Vivek

[Former Member]

According to the below link they are calling the procedures

But I am unable to pass scalar parameters to procedures

Please help me.