14.1 結果の型に使用される定数および属性
次の定数は、t_error
およびt_error_result
型のAPIパラメータp_display_location
および属性display_location
に使用されます。
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';
次の定数は、t_error
型でAPIパラメータassociated_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';
次のレコード構造はエラー処理コールアウト・ファンクションに渡され、またエラーの関連情報がすべて格納されています。
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 */
);
次のレコード構造は、エラー処理コールアウト・ファンクションから戻される必要があります。
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 */
);
親トピック: APEX_ERROR