Interactive Scripts, return codes

Interactive scripts in Unix.
[Quoted] Return codes from Oracle, or Unix.

I want to run a script in Unix,
[Quoted] that will call

1)	Oracle sqlplus
2)	Oracle sqlloader
3)	Oracle sqlplus. 

[Quoted] At certain points in the script,
I want to ask the user different
questions, and accept Yes or No responses. How can I accomplish this, or,
what is the command to do this?

The other thing that I want to do,
is to check the return codes from
Oracle, and abort if the commands
failed. How can this be accomplished?
[Quoted] How could I branch to another part of
the script?
[Quoted] Would the return code be from Unix,
or from Oracle?

Sorry for such basic questions,
I am rather new to these subjects.

Thanks in Advance,

Rodger Lepinsky
ADP Systems Partnership
Winnipeg, Manitoba, Canada Received on Thu Jun 05 1997 - 00:00:00 CEST