Re: The sql in Bourne shell takes long time
Date: 16 Nov 2006 08:14:17 -0800
Message-ID: <1163693657.630406.207590_at_f16g2000cwb.googlegroups.com>
[Quoted] lovecreatesbea..._at_gmail.com schreef:
> 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.
>
> 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.
Nope... your own.
You update and use a select - did you test this statement in a plain session? Received on Thu Nov 16 2006 - 17:14:17 CET