Re: The sql in Bourne shell takes long time

Lars Tetzlaff wrote:
> 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?

Thank you.

[Quoted] You're right. I am sorry to post it incorrectly. I commented this part:  > /dev/null 2>&1 in first my code for testing purpose. It runs correctly later, perhaps the table locked by anoher application. Received on Thu Nov 16 2006 - 14:17:18 CET