Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can i send SMS from oracle database using plsql function

BijuRajan6343299Sep 18 2018 — edited Apr 1 2020

Hi,

i have registered with a mobile service provider for sending sms.

I received a sample  SMS  API FUNCTION  (the code is pasted below).

How can i send SMS to mobiles with the below code. Kindly support ...

Function

------------

Create or replace function XX_MG_Send_MSG

(

P_User_Name in varchar2,

P_Password  in varchar2,

P_numbers   in varchar2,

P_Sender    in varchar2,

P_msg       in varchar2,

P_dateSend  in varchar2 default 0,

P_timeSend  in varchar2 default 0,

P_deleteKey in varchar2,

P_msgKey    in varchar2

)

Return varchar2 is

Begin

Return 'http://www.mobily.ws/api/msgSend.php?mobile='||P_User_Name||'&'||'password='||P_Password||'&'||'numbers='||P_numbers||'&'||'sender='||P_sender||'&'||'msg='||xx_unicode(P_msg)||'&'||'dateSend='||nvl(P_dateSend,0)||'&'||'timeSend='||nvl(P_timeSend,0)||'&'||'msgId='||P_msgKey||'&'||'applicationType=67';

End XX_MG_Send_MSG;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 18 2019
Added on Sep 18 2018
21 comments
5,958 views