Skip to Content
Author's profile photo Gokul Gawande
Gokul Gawande
August 28, 2015 1 minute read

Different ways to execute/call Stored Procedure in BODS

Hi All,

Here are some ways you can call/execute a Stored Procedure in BODS –

       1. One way is you make a stored procedure in database then call it in job using script below..

              

               sql(‘datastore’,’exec Stored_Procedure_Name’);

      2. Other way to achieve it – import your stored procedure in function..

              

               Goto Datastore -> Function

               right click on function say import – provide your stored procedure name and import

      3. If you have already imported the Stored procedure then you can call it using lookup function in query transform

         

              Once imported you will be able to see the datastore name in lookup- further select the datastore and then you’ll see the Stored Procedure name.



Note:  You can also refer this article for step by step information – Execute Stored Procedure from BODS and then start data extraction from SQL Table



Regards,

Gokul

+91-7588589933

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Nirav Shah
      Nirav Shah

      Hi Gokul,

       

      How do you call the functions of Oracle Package in SAP BODS in Query transform? This function  takes inputs as column value and a varchar key and returns you encrypted value. So, it may be like, runtime call to this function to receive output as dynamic value based on the column value you feed as input.

      Author's profile photo Raghu sai
      Raghu sai

      Hi,

      I have a requirement in sap bods, am calling hana procedure thru' script in sap bods and it has input parameter , so i have created global variable in bods and when i pass value to global variable it has multiple output values, to capture output values i have created variable and i want display them in output using print function .

      But am facing issue , only 1 output value is passing to variable , how to pass multiple values at a time or any other alternative solution .

      Thanks

      Raghu