DSXchange

I'd like to know how can i call a Stored Procedure in a job, i want to use the stage StoredProcedure, but this only have the option of uns Oracle SP, and i want to call a SQL SP, thanks for your answers.

You can use SP stage in 7.5, if not you may be able to use a non-ODBC stage's Before-SQL tab to issue a CALL statement. Search the forum lot of info is present for SP.

Hi,

If there is no return from stored procedure then we can use ODBC Stage to run. Just select user defined sql and ..

Exec StoredProcedure_Name(Parm1,Parm2)


Thanks,

--Anupam

Thank you, very much, finally y found the answered to my problem a head in the forum....greetings.

------------------------
Angel Martinez
Mexico