14.9 AUTO_SET_ASSOCIATED_ITEM Procedure
This procedure automatically sets the associated page item or tabular form column based on a constraint contained in p_error.ora_sqlerrm
.This procedure performs the following:
-
Identifies the constraint by searching for the
schema.constraint
pattern. -
Only supports constraints of type P, U, R and C.
-
For constraints of type C (check constraints), the procedure parses the expression to identify those columns that are used in the constraints expression.
-
Using those columns, the procedure gets the first visible page item or tabular form column that is based on that column and set it as associated
p_error_result.page_item_name
orp_error_result.column_alias
. -
If a page item or tabular form column was found,
p_error_result.display_location
is set toapex_error.c_inline_with_field_and_notif
.
Syntax
APEX_ERROR.AUTO_SET_ASSOCIATED_ITEM (
p_error_result IN OUT nocopy t_error_result,
p_error IN t_error );
Parameters
Table 14-6 AUTO_SET_ASSOCIATED_ITEM Procedure Parameters
Parameters | Description |
---|---|
|
The result variable of your error handling function. |
|
The |
Example
See an example of how to use this procedure in "Example of an Error Handling Function."
Parent topic: APEX_ERROR