ODBC Connection Timeout

oacvb · Post by **oacvb** » Sun Jul 02, 2006 9:47 pm

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.

kumar_s · Post by **kumar_s** » Sun Jul 02, 2006 11:29 pm

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

loveojha2 · Post by **loveojha2** » Mon Jul 03, 2006 2:31 am

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

DSguru2B · Post by **DSguru2B** » Mon Jul 03, 2006 6:48 am

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