In shell script I have one oracle sql block . Suppose the sql block gives ant oracle exception.Then we stop the process.
I know in oracle how to stop it. e.g. I have used Exit keyword and come out from sql block.
But in unix how can we stop the process if sql error occurs.
How will user know the error e.g. no_data_found
Please Give me the examples of unix shell script and in that they call oracle sql code.