![]() Consider the following Oracle SQL*Plus script: Oracle SQL Plus will then exit if an error occurs. Stopping Oracle SQL*Plus Scripts When They Go Wrong. If you use sqlplus in your unix shell script then you can use the exit code from sqlplus to check. But in unix how can we stop the process if sql error occurs. exit, Script executed with error return code or executable terminated abnormally. DIAGNOSIS: Error message: Executable F:/oracle/_SID_/11203/bin/sqlplus returns 1. Exit a SQLPlus script if Day _ 20 ERROR at line 9: Call one "exit.sql" and put an "exit" command in it Here is the modified code. However, starting in the 11g sqlplus (not the database), Oracle has provided a error logging facility. Oops, both updates statements executed, script did not exit after error. I am actually calling an SQL script from Unix using the below code. started adding into my scripts is exiting sqlplus on error and returning the ORA error code. ![]() Oracle Sqlplus Exit Error Code Chronicling Life, Love, Linux and Oracle database administration. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |