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