ksh command sqlplus and timeout

[Leo The Cat]

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.

[James R. Ferguson · Accepted solution]

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

[Leo The Cat]

Hi James

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

Excellent
Thanks a lot.

Bests Regards
Den