ماهي الطريقه لكي أستطيع إرسال رساله إلى الجوال عن طريف أوراكل فورم 6i  أو عن طريق قاعدة البيانات 11g

http://www.smscountry.com/Developers.aspx?code=httpjava&sft=1

 

Steps to integrate SMSCountry Oracle API in Oracle System.

 

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

1) Download the SMSCountry_Oracle_API.plb file and copy .plb file from it into D drive.
3) In SqlPlus run below command
sql> @D:\SMSCountry_Oracle_API.plb;
4) You will see message as "package created" and "package body created".
5) Now to send SMS call function SendSMS as
a) Declare all variables as below and initialize them with your account details and sms parameters. Set Proxy_Str as "Your ProxyIP:Your Proxy port". If you don't have proxy then pass it as empty.
sql> VARIABLE Response VARCHAR2(500);
sql> VARIABLE username VARCHAR2(15);
sql> VARIABLE password VARCHAR2(15);
sql> VARIABLE mobile_numbers VARCHAR2(500);
sql> VARIABLE message VARCHAR2(500);
sql> VARIABLE Sender-ID VARCHAR2(15);
sql> VARIABLE Message_Type CHAR;
sql> VARIABLE Proxy_Str VARCHAR2(20);
 Use any of below methods to call the SendSMS function.
sql> Call SMSCountry_Oracle_API.SendSMS(username, password, mobile_numbers,message,Sender-ID,Message_Type,Proxy_Str) into :Response;
sql> Print Response;

ORselect SMSCountry_Oracle_API.SendSMS(username, password, mobile_numbers,message,Sender-ID,Message_Type,Proxy_Str) from dual;
6) To check delivery status of the message, call GetDR function as:
a) Declare all variables as below and initialize them with your account details and Job-Id. Set Proxy_Str as "Your ProxyIP:Your Proxy port". If you don't have proxy then pass it as empty.
sql> VARIABLE Response VARCHAR2(500);
sql> VARIABLE username VARCHAR2(15);
sql> VARIABLE password VARCHAR2(15);
sql> VARIABLE SMS_Job_ID VARCHAR2(16);
  Use any of below methods to call the GetDR function.
sql> Call SMSCountry_Oracle_API.GetDR(username, password, SMS_Job_ID,Proxy_Str) into :Response;
sql> Print Response;

ORselect SMSCountry_Oracle_API.SendSMS(username, password, SMS_Job_ID,Proxy_Str) from dual;

اخي الكريم SAYYAD17  ممكن لو تكرمت تحمل الملف SMSCountry_Oracle_API.plb لاني لم اجده  في جوجل ولك جزيل الشكر