There are some more information about the scenario:
The application server is in the DMZ zone and the database is in the trusted zone. Is the problem related to the time out of the tcpip or the settings of the oracle database ?
Please help.
Search found 2 matches
- 09 Feb 2010 19:35
- Forum: DOS Batch Forum
- Topic: Perl script that run long time and did not return result cod
- Replies: 1
- Views: 3015
- 09 Feb 2010 04:02
- Forum: DOS Batch Forum
- Topic: Perl script that run long time and did not return result cod
- Replies: 1
- Views: 3015
Perl script that run long time and did not return result cod
I have a Perl script that called a sql file and then Oracle stored procedure and run long time (about 1.5 hours). It called the sql by $rtnCode = system(sqlplus -s job.sql); I have the following code to check the return code: if (($rtnCode >>= 8) != 0) { writeErr("Failed to run the job"); ...