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.
