Executing Stored Procedures from DataStage

[yaminids]

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

[bunu1977]

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.

[yaminids]

Thanks Dilip. I will try it

Yamini

[DataStageCnu]

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...