DSXchange

Hi,

I am calling a oracle stored procedure by using ODBC Stage. Job got aborted if Stored Procedure runs more than 30 Minutes. Please suggest some idea to resolve it. Is there any alternative to call a stored procedure from job. Thanks for your help.

You call even using native oracle stage in user defined query. {call storedprocedure(?,?,...)}. but what is the error message given when it got aborted.

I guess this is something that you need to specify at the time of ODBC connection creation (DSN creation).

What version are you on, 7.5 has a stored procedure stage. That stage can make your life much easier.