AOP_LOG25_PKG

• Constants
• START_REQUEST Function
• END_REQUEST Procedure

Constants

Others

-- c_aop_version 
c_aop_version constant varchar2(6) := '25.1.2'    

START_REQUEST Function

When there's a call to AOP (aop_api_pkg.plsql_call_to_aop), this function logs the request (start)

Syntax

function start_request (
  p_data_type                in varchar2,
  p_data_source              in clob,
  p_template_type            in varchar2,
  p_template_source          in clob,
  p_output_type              in varchar2,
  p_output_filename          in varchar2 default null,
  p_output_type_item_name    in varchar2 default null,
  p_output_to                in varchar2 default null,
  p_procedure                in varchar2 default null,
  p_binds                    in varchar2 default null,
  p_special                  in varchar2 default null,
  p_aop_remote_debug         in varchar2 default null,
  p_output_converter         in varchar2 default null,
  p_aop_url                  in varchar2,
  p_api_key                  in varchar2,
  p_aop_mode                 in varchar2 default null,
  p_app_id                   in number   default null,
  p_page_id                  in number   default null,
  p_user_name                in varchar2 default null,
  p_init_code                in clob     default null,
  p_output_encoding          in varchar2 default null,
  p_output_split             in varchar2 default null,
  p_output_merge             in varchar2 default null,
  p_output_even_page         in varchar2 default null,
  p_output_merge_making_even in varchar2 default null,
  p_failover_aop_url         in varchar2 default null,
  p_failover_procedure       in varchar2 default null,
  p_log_procedure            in varchar2 default null,
  p_prepend_files_sql        in clob     default null,
  p_append_files_sql         in clob     default null,
  p_compare_files_sql        in clob     default null,
  p_media_files_sql          in clob     default null,
  p_sub_templates_sql        in clob     default null,
  p_attachments_sql          in clob     default null,
  p_ref_cursor               in clob     default null,
  p_sql_array                in clob     default null,
  p_ig_selected_pks          in varchar2 default null
) return number

Parameters

Name	Description
p_data_type	As defined in aop_api_pkg
p_data_source	As defined in aop_api_pkg
p_template_type	As defined in aop_api_pkg
p_template_source	As defined in aop_api_pkg
p_output_type	As defined in aop_api_pkg
p_output_filename	As defined in aop_api_pkg
p_output_type_item_name	As defined in aop_api_pkg
p_output_to	As defined in aop_api_pkg
p_procedure	As defined in aop_api_pkg
p_binds	a varchar2 representing the binds
p_special	As defined in aop_api_pkg
p_aop_remote_debug	As defined in aop_api_pkg
p_output_converter	As defined in aop_api_pkg
p_aop_url	As defined in aop_api_pkg
p_api_key	As defined in aop_api_pkg
p_aop_mode	As defined in aop_api_pkg
p_app_id	As defined in aop_api_pkg
p_page_id	As defined in aop_api_pkg
p_user_name	As defined in aop_api_pkg
p_init_code	As defined in aop_api_pkg
p_output_encoding	As defined in aop_api_pkg
p_output_split	As defined in aop_api_pkg
p_output_merge	As defined in aop_api_pkg
p_output_even_page	As defined in aop_api_pkg
p_output_merge_making_even	As defined in aop_api_pkg
p_failover_aop_url	As defined in aop_api_pkg
p_failover_procedure	As defined in aop_api_pkg
p_log_procedure	As defined in aop_api_pkg
p_prepend_files_sql	As defined in aop_api_pkg
p_append_files_sql	As defined in aop_api_pkg
p_compare_files_sql	As defined in aop_api_pkg
p_media_files_sql	As defined in aop_api_pkg
p_sub_templates_sql	As defined in aop_api_pkg
p_attachments_sql	As defined in aop_api_pkg
p_ref_cursor	a clob representing the ref cursor
p_sql_array	a clob representing the sql array
p_ig_selected_pks	As defined in aop_api_pkg
return	the id of the log, which can be used in the end_request procedure

END_REQUEST Procedure

When there's a call to AOP (aop_api_pkg.plsql_call_to_aop), this function logs the request (end)

Syntax

procedure end_request (
  p_aop_log_id            in number,  
  p_status                in varchar2, 
  p_aop_json              in clob,
  p_aop_error             in varchar2, 
  p_ora_sqlcode           in number, 
  p_ora_sqlerrm           in varchar2
)

Parameters

Name	Description
p_aop_log_id	id which was returned by start_request
p_status	Status
p_aop_json	JSON generated by AOP
p_aop_error	Error message
p_ora_sqlcode	SQL Error Code
p_ora_sqlerrm	SQL Error Message