AOP PL/SQL - API Documentation


Created by Dimitri Gielis on 12/12/2015
Package to show how to make a manual call with PL/SQL to the AOP Server If APEX is not installed, you can use this package as your starting point but you would need to change the apex_web_service calls by utl_http calls or similar.



c_aop_version constant varchar2(5) := '19.2'


Created by Dimitri Gielis on 9/1/2018
Example how to make a manual call to the AOP Server and generate the correct JSON.


function make_aop_request(
  p_aop_url          in varchar2 default g_aop_url,
  p_api_key          in varchar2 default g_api_key,
  p_aop_mode         in varchar2 default g_aop_mode,
  p_json             in clob,
  p_template         in blob,
  p_template_type    in varchar2 default null,
  p_output_encoding  in varchar2 default 'raw',  
  p_output_type      in varchar2 default null,
  p_output_filename  in varchar2 default 'output',
  p_aop_remote_debug in varchar2 default 'No')
  return blob


  • p_aop_url URL of AOP Server
  • p_api_key API Key in case AOP Cloud is used
  • p_json Data in JSON format
  • p_template Template in blob format
  • p_output_encoding Encoding in raw or base64
  • p_output_type The extension of the output e.g. pdf, if no output type is defined, the same extension as the template is used
  • p_output_filename Filename of the result
  • p_aop_remote_debug Ability to do remote debugging in case the AOP Cloud is used

  • Return

  • Resulting file where the template and data are merged and outputted in the requested format (output type).