AOP PL/SQL - API Documentation

aop_error19_pkg

Created by Dimitri Gielis on 12/12/2015
Error handling package used in the AOP Sample App.

Function APEX_ERROR_HANDLING

Created by Dimitri Gielis on 9/1/2018
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

  • p_error Error we get in APEX

  • Return

  • Nicer error message

Procedure ADD_ERROR_LOG

Created by Dimitri Gielis on 9/1/2018
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

  • 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