Hi Guys,

I have problem in Visual Basic with Oracle 8.1. I am using VB6 with ADO 2.6 which is running on WIN2K.I have a stored procedure which is having multiple sub procedures. I am passing parameter through VB. Moments it runs after few seconds it is coming out from session without completing stored procedure.

Is is there any failure in CommandTimedOut. if that how do i increase my timedout values.Though it found the same problem.

What ADO connection should i use for run a Oracle stored procedure with full complete execution of stored procedure. if you have answer . Pls send a mail the following mail ID. vazanth2004@rediffmail.com