AOP PL/SQL - API Documentation

aop_log19_pkg

Created by Dimitri Gielis on 12/12/2015
Example of additional logging package.

Constants

Others

c_aop_version
c_aop_version constant varchar2(5) := '19.1'

Function START_REQUEST

Created by Dimitri Gielis on 9/1/2018
When there's a call to AOP (aop_api19_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_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_sub_templates_sql     in clob     default null
) return number

Parameters

  • 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_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_sub_templates_sql As defined in aop_api_pkg

  • Return

  • Description

Procedure END_REQUEST

Created by Dimitri Gielis on 9/1/2018
When there's a call to AOP (aop_api19_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

  • 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