topic ksh command sqlplus and timeout in Operating System - HP-UX

ksh command sqlplus and timeout

Leo The Cat — Tue, 15 Feb 2011 19:44:45 GMT

Hi

huh I'm probably turning around the solution.

Here my draft (of course it doesn't works)

spout="$(

$ORACLE_HOME/bin/sqlplus -silent "/ as sysdba" << EOF &
set echo off feedb off head off

connect test/test

/

exit success
EOF
sleep 4
kill %% 2>&1
)"

IN fact, i want to run this command and terminate after 5 seconds whatever is finished or not. (because sometime if instance not available cionnection is hanging)

Could you help me to find the good key. I'm not too far ....

Bests regards
Den.

Re: ksh command sqlplus and timeout

James R. Ferguson — Tue, 15 Feb 2011 22:16:34 GMT

Hi Den:

You could do:

#!/usr/bin/sh
function worker {
spout="$( ...
...
EOF
)
}
worker &
WORKER_PID=$!
sleep 5
kill ${WORKER_PID} 2>/dev/null
exit 0

Regards!

...JRF...
kill

Re: ksh command sqlplus and timeout

Leo The Cat — Wed, 16 Feb 2011 21:24:15 GMT

Hi James

Of course the trick with a function. It's the key !

Excellent
Thanks a lot.

Bests Regards
Den