Package sms_util_pkg

Variables, constants

const g_format_xml 

g_format_xml constant varchar2(255):='xml'

response formats

const g_format_json 

g_format_json constant varchar2(255):='json'

const g_format_custom 

g_format_custom constant varchar2(255):='custom'

var g_exec_result_string 

g_exec_result_string varchar2(4000)

internal variable used for dynamic PL/SQL evaluation

Functions, procedures

procedure set_wallet 

procedure set_wallet(
    p_wallet_path in varchar2,
    p_wallet_password in varchar2
)

set SSL wallet properties

procedure set_gateway_config 

procedure set_gateway_config(
    p_gateway_config in t_gateway_config
)

set gateway configuration

procedure send_sms 

procedure send_sms(
    p_message in varchar2,
    p_to in varchar2,
    p_from in varchar2,
    p_attr1 in varchar2:=null,
    p_attr2 in varchar2:=null,
    p_attr3 in varchar2:=null,
    p_username in varchar2:=null,
    p_password in varchar2:=null
)

send SMS message

Types

record t_gateway_config 

type t_gateway_config is record(
    send_sms_url varchar2(4000),
    username varchar2(255),
    password varchar2(255),
    response_format varchar2(30),
    response_error_path varchar2(4000),
    response_error_namespace varchar2(4000),
    response_error_parser varchar2(4000)
)

gateway configuration