in reply to Win32 capturing output from a process that may hang
I would spawn a second Perl process (possibly via system(qq{start "$^X" -w execute_sybase_collector.pl}), which starts sqlplus and writes the output to a file, and writes a .ok-file if it has completed. If the .ok file doesn't exist after 110 seconds, report the failure, otherwise report the result of the SQL query.
|
|---|