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.
