Skip to main content

AOP_ERROR24_PKG

APEX_ERROR_HANDLING Function

Try to elegantly handle errors that occur while using the application.

Syntax

function apex_error_handling ( p_error in apex_error.t_error )
return apex_error.t_error_result

Parameters

NameDescription
p_error

Error we get in APEX

returnNicer error message

ADD_ERROR_LOG Procedure

Logs application errors

Syntax

procedure add_error_log (
p_error in varchar2 default null,
p_procedure_name in varchar2 default null,
p_page_item_name in varchar2 default null,
p_region_id in varchar2 default null,
p_column_alias in varchar2 default null,
p_row_num in varchar2 default null,
p_apex_error_code in varchar2 default null,
p_ora_sqlcode in varchar2 default null,
p_ora_sqlerrm in varchar2 default null,
p_error_backtrace in varchar2 default null,
p_arg1_name in varchar2 default null,
p_arg1_val in varchar2 default null,
p_arg2_name in varchar2 default null,
p_arg2_val in varchar2 default null,
p_arg3_name in varchar2 default null,
p_arg3_val in varchar2 default null,
p_arg4_name in varchar2 default null,
p_arg4_val in varchar2 default null,
p_arg5_name in varchar2 default null,
p_arg5_val in varchar2 default null,
p_arg6_name in varchar2 default null,
p_arg6_val in varchar2 default null,
p_arg7_name in varchar2 default null,
p_arg7_val in varchar2 default null,
p_arg8_name in varchar2 default null,
p_arg8_val in varchar2 default null,
p_arg9_name in varchar2 default null,
p_arg9_val in varchar2 default null,
p_arg10_name in varchar2 default null,
p_arg10_val in varchar2 default null )

Parameters

NameDescription
p_error

Error message

p_procedure_name

Procedure

p_page_item_name

Page Item

p_region_id

Region

p_column_alias

Column

p_row_num

Row

p_apex_error_code

APEX Error

p_ora_sqlcode

SQL Error Code

p_ora_sqlerrm

SQL Error Message

p_error_backtrace

Backtrace