DSXchange

I have tried to execute one procedure in stage ODBC: User-defined
SQL=call nameprocedure(); The procedure is executed several times
(loop). How I can avoid the loop?

Thanks

I have tried to execute one procedure in stage ODBC: User-defined
SQL=call nameprocedure(); The procedure is executed several times
(loop). How I can avoid the loop?

Thanks

I have tried to execute one procedure in stage ODBC: User-defined
SQL=call nameprocedure(); The procedure is executed several times
(loop). How I can avoid the loop?

Thanks

Sainath.Srinivasan wrote:Use the 'Stored Procedure' stage from v7 onwards.

can you be most specify?
thank

Hi,
I would like to know, how to use the store procedure (Oracle) with Data Stage.

thank you

Peppinodicapri