posted 17 years ago
Yeah - I have the commands and i am trying my hands on the same.
I run into a few questions like:
I am using something like:
1 START=$(date +%s)
2 remain=30
3 sleep $remain
4 END=$(date +%s)
5 DIFF=$(( $END - $START))
6 echo "it took $DIFF secs"
7 sqlplus -s user_id/PWD@host <<EOF>
8 exec stored_proc;
9 EXIT;
10 EOF
This logic may not seem to be much relevant but this in in draft version for now.
Now I need to perform while i am in SQL connection, but if i insert statements 1-6 inside 7-10. It gives me error for each of the command - not found error which is expected since they are not sql commands.
Can somebody tell me what should be the way to do this. Thanks.