Re: Problem with a conection...

It sounds to me as if you're running into something else.  As far as I 
know, the 2396 error should not be triggered during a select as the 
connection is not 'idle'.  Could it be that your select statement is 
finishing more quickly than you thought and you're not picking it up?  
If that was the case, then your session could be described as 'idle'

Cheers

Martin

On 08/06/2010 14:54, Juan Carlos García wrote:
> Hi.
> I have a program that takes around six or seven hours to execute.
> I don't kwon when but, during the execution of a SELECT statement, I 
> get this error:
>
> DBD::Oracle::db prepare failed: ORA-02396: exceeded maximum idle time, 
> please connect again (DBD ERROR: OCIStmtExecute/Describe) [for 
> Statement ........
>
> The cause of the error is clear for me. But the problem is, how to 
> resolve it?
> What should I do to reconnect with the database when I suffer a 
> disconnection?
>
> Sorry for my english.
> Any idea will be apreciated.
> Thanks.
>