Different ways to execute/call Stored Procedure in BODS

[Former Member]

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