Procedure Calling

[ORACLE_1]

A beginner in Datastage -

That being said I saw lots of posts on running Stored Procedures in Datastage but still I am not very clear on it.

All I what want to do is run the following procedure the simplest way possible -

exec DBMS_CDC_SUBSCRIBE.extend_window(SUBSCRIPTION_NAME => 'abc') ;

Do I do it in Database Stage , Server Job , Seqeunce Job , Command , SP stage etc.?

Thanks in Advance !!

[ray.wurlod]

Stored Procedure stage, surely?

At least most of the time. A stored procedure that deals with a recordset might be included in a database stage type, such as ODBC stage.

[chulett]

Instead of raising a new topic I just takes this one hostage...

Bad idea. I've moved your takeover attempt to its own topic.

[qutesanju]

you can call a SP using ODBC stage /command stage/stored procedure stage also
1.ODBC is simplest way to call backend SP
2. in command stage you have to write a code in batch file to call SP and call this batch file in command stage

[ORACLE_1]

Created a SP in the database which is based on the package which I mentioned.

And Now i do simple call from DRS in my job in the post SQL stage.

Thanks for all your help guys !