The following constants are used for the API parameter p_display_location
and the attribute display_location
in the t_error
and t_error_result
types.
c_inline_with_field constant varchar2(40):='INLINE_WITH_FIELD'; c_inline_with_field_and_notif constant varchar2(40):='INLINE_WITH_FIELD_AND_NOTIFICATION'; c_inline_in_notification constant varchar2(40):='INLINE_IN_NOTIFICATION'; c_on_error_page constant varchar2(40):='ON_ERROR_PAGE';
The following constants are used for the API parameter associated_type
in the t_error
type.
c_ass_type_page_item constant varchar2(30):='PAGE_ITEM'; c_ass_type_region constant varchar2(30):='REGION'; c_ass_type_region_column constant varchar2(30):='REGION_COLUMN';
The following record structure is passed into an error handling callout function and contains all the relevant information about the error.
type t_error is record ( message varchar2(32767), /* Error message which will be displayed */ additional_info varchar2(32767), /* Only used for display_location ON_ERROR_PAGE to display additional error information */ display_location varchar2(40), /* Use constants "used for display_location" below */ association_type varchar2(40), /* Use constants "used for asociation_type" below */ page_item_name varchar2(255), /* Associated page item name */ region_id number, /* Associated tabular form region id of the primary application */ column_alias varchar2(255), /* Associated tabular form column alias */ row_num pls_integer, /* Associated tabular form row */ is_internal_error boolean, /* Set to TRUE if it's a critical error raised by the APEX engine, like an invalid SQL/PLSQL statements, ... Internal Errors are always displayed on the Error Page */ apex_error_code varchar2(255), /* Contains the system message code if it's an error raised by APEX */ ora_sqlcode number, /* SQLCODE on exception stack which triggered the error, NULL if the error was not raised by an ORA error */ ora_sqlerrm varchar2(32767), /* SQLERRM which triggered the error, NULL if the error was not raised by an ORA error */ error_backtrace varchar2(32767), /* Output of sys.dbms_utility.format_error_backtrace or sys.dbms_utility.format_call_stack */ error_statement varchar2(32767), /* Statement that was parsed when the error occurred - only suitable when parsing caused the error */ component apex.t_component /* Component which has been processed when the error occurred */ );
The following record structure must be returned by an error handling callout function.
type t_error_result is record ( message varchar2(32767), /* Error message which will be displayed */ additional_info varchar2(32767), /* Only used for display_location ON_ERROR_PAGE to display additional error information */ display_location varchar2(40), /* Use constants "used for display_location" below */ page_item_name varchar2(255), /* Associated page item name */ column_alias varchar2(255) /* Associated tabular form column alias */ );