How to use dynamic sql procedure inside odata service

[former_member225922]

Hi,

     I have created one catalog procedure with dynamic sql statements. I need to use this procedure inside ui5 control so i need to use the procedure with odata service. Is there anyway to use the procedure call inside odata service definition.

[thomas_jung]

>Is there anyway to use the procedure call inside odata service definition.

No, there is no direct way.  Instead you wrap your procedure in a calculation view and then use the calculation view as the source of the OData service.  XSODATA only supports tables and views as the entity source.

[sreehari_vpillai]

Hi sujitha, are you using netweaver gateway to expose OData or XS services ? sree

[former_member225922]

Hi Sreehari

     I am not using any netweaver gateway