Problem with a conection...
[email protected] (Juan Carlos García)
| Newsgroups | perl.dbi.users |
|---|---|
| Message-ID | <[email protected]> |
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.