AOP_LOG24_PKG

• Constants
• START_REQUEST Function
• END_REQUEST Procedure

Constants

Others

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

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_failover_aop_url      in varchar2 default null,
  p_failover_procedure    in varchar2 default null,
  p_prepend_files_sql     in clob     default null,
  p_append_files_sql      in clob     default null,
  p_media_files_sql       in clob     default null,
  p_sub_templates_sql     in clob     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	As defined in aop_api_pkg
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_failover_aop_url	As defined in aop_api_pkg
p_failover_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_media_files_sql	As defined in aop_api_pkg
p_sub_templates_sql	As defined in aop_api_pkg
return	Description

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