Details
-
Fix
-
Status: Released (View Workflow)
-
Minor
-
Resolution: Fixed
-
2.3.1
-
None
Description
Current Situation
- The JITL SQLPLUSJob throws a NullPointerException if the SQL statements to execute includes errors, for example when executing the following SQL statements from the command argument
select 1 from dual; exit;
- The above SQL statement is wrong as it includes two statements in the same line. The correct syntax is:
select 1 from dual; exit;
- The above wrong SQL statements result in the error message:
msg=java.lang.NullPointerException
Desired Behavior
- The JITL SQLPLUSJob should show the correct error message provided by SQLPlus if the script to execute includes errors.
- For the above example the correct error message is:
SQL Exception raised. Msg='ORA-00933: SQL command not properly ended'