GET_FIRST_ORA_ERROR_TEXT Function

25.10 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

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.

Parent topic: APEX_ERROR