DSXchange

Hello friends,

Is it possible to execute a Stored Procedure from DataStage which does not return any rows by calling it from either ODBC Stage or ORA 9I Stage?

Any thoughts would be highly appreciated
Yamini

Hi,
Yes it is possible . Long back I have done it using ORAOCI stage .
write like

Begin
Procedure name
End;

Try in Before or After tab of ORAOCI stage.

Thanks Dilip. I will try it

Yamini

yaminids wrote:Hello friends,

Is it possible to execute a Stored Procedure from DataStage which does not return any rows by calling it from either ODBC Stage or ORA 9I Stage?

Any thoughts would be highly appreciated
Yamini

I believe, you can do it by ODBC stage. One of the advantage of ODBC is... can work with Stored procedures...