Sqlplus return code windows

Registered User. Join Date: Jun Dear all, How to make sqlplus command to exit with an apt error code in bash script, It always returns 0 for me. Administrator Emeritus. Under what circumstances would you like it to exit with an error sorry, not sure what you mean by "apt error"!

You could, perhaps look at: Code :. Code :. In case, if procedure in a file have thrown an exception i need to block some code of execution in a script. Thanks every1. I'm somewhat confused by your use of terminology. I would consider an "sqlplus" command to be something like "set", "show", etc.

I can able to handle the exception there. I am doing in all these operations in a single. Join Date: Nov SQLPlus always returns zero, because the command always works. It may not do what you want, but the unix command does not fail.

Shell Programming and Scripting. Function - Make your function return an exit status. Hi All, Good Day, seeking for your assistance on how to not perform my 2nd, 3rd,4th etc..

Exit when sql script give error. Make expect exit the UNIX script in erreneous condition. You need to declare the error condition handling before the error occurs: Whenever sqlerror exit sql. For instance you could do do a protective drop before create, by ignoring an error on the drop, but still stopping if the next step fails: whenever sqlerror continue drop Improve this answer.

Alex Poole Alex Poole k 9 9 gold badges silver badges bronze badges. That might come in useful. Phil — user Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.

Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Add a comment. Active Oldest Votes. Improve this answer. Kerri Shotts Kerri Shotts 1, 7 7 silver badges 7 7 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.

The Overflow Blog.