Store Procedures

Honest_Words · **Joined:** Sat Mar 12, 2005 10:44 pm **Posts:** 10

Can we call the stored procedures in Sql Server through the Teleflow. if yes how..?

Chris · **Posted:** Tue Mar 15, 2005 5:14 pm

You can. Use the SQL Statement step to run stored procedures in TeleFlow.

Honest_Words · **Joined:** Sat Mar 12, 2005 10:44 pm **Posts:** 10

Thanks..!! it is woking.. trying to pass parameters in procedure ..

Honest_Words · **Joined:** Sat Mar 12, 2005 10:44 pm **Posts:** 10

It is working without paramenters and with input parametres, with output parameter runs without error but do not return the value. Here is the procedure defination. Create proc AppName @DNIS varchar(5), @App varchar(30) output as begin select @App = ApplicationName from Inbound where DNIS = @DNIS end And I am calling it through Sql Statement Step. In Sql statement AppName @DNIS, @APP OUTPUT here @APP is Global Variable.