EXTRACT_CONSTRAINT_NAME Function

25.9 EXTRACT_CONSTRAINT_NAME Function

This function extracts a constraint name contained in p_error.ora_sqlerrm. The constraint must match the pattern schema.constraint.

Syntax

APEX_ERROR.EXTRACT_CONSTRAINT_NAME (
    p_error          IN t_error,
    p_include_schema IN BOOLEAN DEFAULT FALSE )
    RETURN VARCHAR2;

Parameters

Parameters	Description
`p_error`	The `p_error` parameter of your error handling function.
`p_include_schema`	If set to `TRUE`, the result is prefixed with the schema name. For example, `HR.DEMO_PRODUCT_INFO_PK`. If set to `FALSE`, only the constraint name is returned.

Example

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

Parent topic: APEX_ERROR