Had a PL/SQL application fail today on an Oracle 19 server with an error code of ORA-20547. Unfortunately, the code in question only dumps the ORA- code, it doesn't supply the SQLERRM value. (The evils that developers do live after them... :-). I've hunted online and haven't found any info on this error. Any info, hints, or references appreciated.

CodePudding user response：

Error numbers from 20000 to 20999 are user-generated errors.

You will not find any documentation for them as you need to check the source code for your application.

From the Oracle documentation

Defining Your Own Error Messages: Procedure RAISE_APPLICATION_ERROR

The procedure RAISE_APPLICATION_ERROR lets you issue user-defined ORA- error messages from stored subprograms. That way, you can report errors to your application and avoid returning unhandled exceptions.

To call RAISE_APPLICATION_ERROR, use the syntax

raise_application_error(
     error_number, message[, {TRUE | FALSE}]);

where error_number is a negative integer in the range -20000 .. -20999 and message is a character string up to 2048 bytes long. If the optional third parameter is TRUE, the error is placed on the stack of previous errors. If the parameter is FALSE (the default), the error replaces all previous errors. RAISE_APPLICATION_ERROR is part of package DBMS_STANDARD, and as with package STANDARD, you do not need to qualify references to it.