Re: The sql in Bourne shell takes long time

lovecreatesbea..._at_gmail.com wrote:
> I have a written following sql statements in the Bourne shell script.
> But when I run the shell script, it takes a long time and doesn't give
> out any result. I have to interrupt it by Ctrl-C or kill -9. The code
> has no syntax errors and the variables like $user, $pass and $sid have
> been assigned before invoking sqlplus.
>
> #...
>
> UMASK=`umask`
> umask 277
> sqlplus -s "$user"/"$pass"_at_"$sid" <<-EOF > /dev/null 2>&1

                                                   ^^^^^^^^^^^^^^^^

why do you expect some output?

Lars Received on Thu Nov 16 2006 - 12:49:33 CET