22.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

Table 22-7 EXTRACT_CONSTRAINT_NAME Function 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 procedure in "Example of an Error Handling Function."