Re: How to return an value from Oracle to Unix in a shell scrtip.

I am un-aware of any settings which affect the "EXIT VALUE" format.

As a test you might want to run a few exit test values to see how they show up in $?

sqlplus tiger/scott <<EOF
exit 100
EOF
echo $?

sqlplus tiger/scott <<EOF
exit 512
EOF
echo $?

gojo (kckcabc_at_email.com) wrote:
: I tried the method of variable_name = `sqlplus tiger/scott`, and it is
: returning me the result i wanted. Do I have to ensure the ORACLE (i.e.
: Serverout, FeedBack ) settings are setup correctly? If so, what are they?

--
While Alcatel may claim ownership of all my ideas (on or off the job),
Alcatel does not claim any responsibility for them. Warranty expired when u
opened this article and I will not be responsible for its contents or use.