This function extracts a constraint name contained in p_error.ora_sqlerrm
. The constraint must match the pattern schema.constrain
t.
Syntax
APEX_ERROR.EXTRACT_CONSTRAINT_NAME ( p_error in t_error, p_include_schema in boolean default false ) return varchar2;
Parameters
Table 8-7 describes the parameters available in the EXTRACT_CONSTRAINT_NAME function.
Table 8-7 EXTRACT_CONSTRAINT_NAME Function Parameters
Parameters | Description |
---|---|
|
The |
|
If set to |
Example
See an example of how to use this procedure in "Example of an Error Handling Function".