Skip to Content
author's profile photo
Former Member

Call a Procedure from SAP XS Odata

Posted on Jan 13, 2015 at 07:09 AM 203 Views

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.

SAP HANA
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Vivek Singh Bhoj
    Posted on 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

  • author's profile photo
    Sreehari V Pillai
    Posted on 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
      Jan 13, 2015 at 09:14 AM

      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.