PL/SQL Documentation error

If an error is raised by the scheduler server software it is done with the oracle PL/SQL command RAISE_APPLICATION_ERROR(-20000,...ERROR MESSAGE...).
An example of an error when using SQL*Plus will be like this:

SQL> execute so_script.delete_script('so_test_script5');
BEGIN so_script.delete_script('so_test_script5'); END;

*
ERROR at line 1:
ORA-20000: OSC-10026 SCRIPT "PLSQL5"."SO_TEST_SCRIPT5" IS STILL IN USE
ORA-06512: at "PLSQLSCH.SO_SHARED", line 3267
ORA-06512: at "PLSQLSCH.SO_SCRIPT", line 1047
ORA-06512: at line 1
  

The first part after ORA-20000 is the scheduler error code, in this example error OSC-10026.
The remaining text on the same line contains the scheduler error message.

Back to top