Skip to Content
avatar image
Former Member

Call a Procedure from SAP XS Odata

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 13, 2015 at 08:10 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 13, 2015 at 08:54 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.