I'd like to know if it's possible to invoke a stored procedure from TeleFlow. <br> <br>I've seen the SQL steps that issue SQL commands directly to a database, but no SQL step to invoke a stored procedure... <br> <br>BTW, I'm using Oracle 9i.

You still use the SQL Statement step. If your stored procedure returns results, you will need to use a Fetch step to retrieve them, the same as for a SELECT statement.

Interesting. Can you give me an example of what would I write in the SQL Statement step? <br> <br>The help text for that step just documents the use and syntax of direct SELECT statements... Will something like this work?: <br> <br>BEGIN <br> MyProcedure (p_param1, p_param2); <br>END; <br> <br>... and then using SQL Fetch to retrieve the output value of, say, p_param2 ?

Try this: <br> <br>execute MyProcedure @p_param1, @p_param2 <br> <br>where both the p_param1 and @p_param2 are variables in Teleflow <br> <br>(I work on MS SQL Server but think it should work on oracle as well) <br> <br>Hope this works <br> <br>Rudi

Thank you, Rudi! The enGenic team appreciates input from TeleFlow developers on the DevNet.