Package flex_ws_api

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

var g_headers

g_headers header_table

var g_request_headers

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

record header

type header is record(
    name varchar2(256),
    value varchar2(1024)
)

varray header_table

type header_table is varray of header index by binary_integer