Dear Sir,
I can send you my program, but it won't work with your DB not hardware. The program package links have to be configured to your DataBase. But here are the steps that should get you there.

Assuming that you already have an Oracle DataBase...

1st: (hardware) you should have an SMS gateway that is configured to PUSH( send SMSs from a table).

2nd: design a webpage (html, or any other language), you can also use javascripts...In your code you should name the text boxes and mobile text area to pass the inputed data to them

3rd: using an SQL editor (ex.Navigator) create a package in your DB and add your html code (it won't be recogdnized till you put your code between htp.p(' and ');

4th: the variables names that you assigned to your inputed areas are to be used in the insert statment that would insert to the table that the SMS gateway sends from.

The insert statment would look like this:

INSERT INTO smsuser.smsmessages (MESSAGEID, SUBSCID, SUBSCUSERID, SENDERID,
MOBILENUMBER, MESSAGETEXT) values (SMSMESSAGES_COUNTER.NEXTVAL, 148,'autoqatar.com', l_name,'974'||mobile_no, messege_body );
commit;

Basically, you should design a page that would manipulate the mobile_no, and the Messege_body.

Good luck...