-
Notifications
You must be signed in to change notification settings - Fork 0
/
nexmo_pkg.sql
37 lines (32 loc) · 931 Bytes
/
nexmo_pkg.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
create or replace package nexmo_pkg as
------------------------------------------------------
-- Package: NEXMO_PKG
-- Author: Christina Moore, @cmoore_sp
--
-- This package is an API for a few of the features found
-- at Nexmo.com for using SMS (text messaging).
--
-- tabs or spaces: Tabs \t
--
-- Revision History
-- 0.1 05FEB2017
--
------------------------------------------------------
function get_balance return number;
procedure send_sms (
p_sms in varchar2,
p_msg in varchar2,
p_client_ref in varchar2 default null,
p_northamerican in varchar2 default 'Y'
);
function verify_code_check (
p_response_pk in number,
p_code in varchar2,
p_ip_address in varchar2 default null
) return varchar2;
function verify_sms (
p_sms in varchar2,
p_brand in varchar2 default null,
p_northamerican in varchar2 default 'Y'
) return number;
end nexmo_pkg;