return code from sqlplus 4

[kasparov]

I'm calling sqlplus in a script & I want to tee the output to a logfile like this:

sqlplus -s my_id/my_pwd <<EOF  | tee -a /tmp/xx
select * from v$instance;
exit
EOF
echo $?

My problem is that the return code ($?) is from the tee command (which always works) & not from the sqlplus (which fails if I enter the wrong id or password). Can anyone suggest how I use the return code from sqlplus?

This works fine if I don't tee the output to a logfile.

Thanks, Chris

 

[LKBrwnDBA]

Try this:

(sqlplus -s my_id/my_pwd <<EOF
select * from v$instance;
exit
EOF
echo $?
)| tee -a /tmp/xx

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[khalidaaa]

Nice work around LKBrwnDBA!

Another possibility is to do this:

sqlplus -s my_id/my_pwd <<EOF  >> /tmp/xx
select * from v$instance;
exit
EOF
echo $?
cat /tmp/xx

Instead of using the tee, you can just cat the file after the lines inside a script! (that's if you still want to capture the return code somewhere inside a script!

Regards,
Khalid

 

[kasparov]

Will prob use LKBrwnDBA's solution but both work fine.

Thanks, Chris

 

[p5wizard]

Depends on if you want to be able to use the SQLRC afterwards, if so, then Khalid's soln is the way to go, because with the (commands)-construct, the SQLRC is short-lived (subshell lifespan only)...

SQLRC='none'
(sqlplus -s my_id/my_pwd <<EOF
select * from v$instance;
exit
EOF
SQLRC=$?
)| tee -a /tmp/xx

echo $SQLRC # will still show none

SQLRC='none'
sqlplus -s my_id/my_pwd <<EOF  >> /tmp/xx
select * from v$instance;
exit
EOF
SQLRC=$?
cat /tmp/xx

echo $SQLRC # correct RC

HTH,

p5wizard

 

[bigoldbulldog]

If you want a transient dump of exit status to stdout and not the tee'd file, you can always play with file descriptors.

((sqlplus -s my_id/my_pwd <<EOF
select * from v$instance;
exit
EOF
echo $? >&3
)| tee -a /tmp/xx 3>&- ) 3>&1

Cheers,
ND