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),
<span class="srcComment">-- either an xpath or jsonpath expression</span>
response_error_namespace varchar2(4000),
<span class="srcComment">-- xml namespace</span>
response_error_parser varchar2(4000)
)
gateway configuration