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.
