Variables, constants
var empty_vc_arr
empty_vc_arr wwv_flow_global.vc_arr2
var g_request_cookies
g_request_cookies utl_http.cookie_table
var g_response_cookies
g_response_cookies utl_http.cookie_table
g_request_headers header_table
var g_status_code
g_status_code pls_integer
Functions, procedures
function blob2clobbase64
function blob2clobbase64(
p_blob in blob
) return clob
function clobbase642blob
function clobbase642blob(
p_clob in clob
) return blob
procedure make_request
procedure make_request(
p_url in varchar2,
p_action in varchar2 default null,
p_version in varchar2 default 1.1,
p_collection_name in varchar2 default null,
p_envelope in clob,
p_username in varchar2 default null,
p_password in varchar2 default null,
p_proxy_override in varchar2 default null,
p_wallet_path in varchar2 default null,
p_wallet_pwd in varchar2 default null,
p_extra_headers in wwv_flow_global.vc_arr2 default empty_vc_arr
)
function make_request
function make_request(
p_url in varchar2,
p_action in varchar2 default null,
p_version in varchar2 default 1.1,
p_envelope in clob,
p_username in varchar2 default null,
p_password in varchar2 default null,
p_proxy_override in varchar2 default null,
p_wallet_path in varchar2 default null,
p_wallet_pwd in varchar2 default null,
p_extra_headers in wwv_flow_global.vc_arr2 default empty_vc_arr
) return xmltype
function make_rest_request
function make_rest_request(
p_url in varchar2,
p_http_method in varchar2,
p_username in varchar2 default null,
p_password in varchar2 default null,
p_proxy_override in varchar2 default null,
p_body in clob default empty_clob(),
p_body_blob in blob default empty_blob(),
p_parm_name in wwv_flow_global.vc_arr2 default empty_vc_arr,
p_parm_value in wwv_flow_global.vc_arr2 default empty_vc_arr,
p_http_headers in wwv_flow_global.vc_arr2 default empty_vc_arr,
p_http_hdr_values in wwv_flow_global.vc_arr2 default empty_vc_arr,
p_wallet_path in varchar2 default null,
p_wallet_pwd in varchar2 default null
) return clob
function parse_xml
function parse_xml(
p_xml in xmltype,
p_xpath in varchar2,
p_ns in varchar2 default null
) return varchar2
function parse_xml_clob
function parse_xml_clob(
p_xml in xmltype,
p_xpath in varchar2,
p_ns in varchar2 default null
) return clob
function parse_response
function parse_response(
p_collection_name in varchar2,
p_xpath in varchar2,
p_ns in varchar2 default null
) return varchar2
function parse_response_clob
function parse_response_clob(
p_collection_name in varchar2,
p_xpath in varchar2,
p_ns in varchar2 default null
) return clob
Types
type header is record(
name varchar2(256),
value varchar2(1024)
)
type header_table is varray of header index by binary_integer