10.11 GET_FIRST_ORA_ERROR_TEXT Function

This function returns the first ORA error message text stored in p_error.ora_sqlerrm. If p_error_ora_sqlerrm does not contain a value, NULL is returned.

Syntax

APEX_ERROR.GET_FIRST_ORA_ERROR_TEXT (
    p_error            in t_error,
    p_include_error_no in boolean default false )
    return varchar2;

Parameters

Table 10-9 GET_FIRST_ORA_TEXT Function Parameters

Parameters	Description
`p_error`	The `p_error` parameter of your error handling function.
`p_include_error_no`	If set to `TRUE`, ORA-xxxx is included in the returned error message. If set to `FALSE`, only the error message text is returned.

Example

See an example of how to use this procedure in "Example of an Error Handling Function."