Home
RECOMMENDED FOR YOU:
SMS Gateway software
Ozeki brings you outstanding
SMS Gateway technology. Use our SMS Server products on Windows,Linux, or Android

C# SMS API
Developers can use our C# SMS API to send SMS from C#.Net. The C# SMS API comes with full source code

PHP SMS API
The ozeki PHP SMS gateway software can be used to send SMS from PHP and to receive SMS usig PHP on your website

SMPP SMS Gateway
SMS service providers use our SMPP gateway solution, that offers a high performance SMPP server and SMPP client gateway with amazing routing capabilities
Ozeki 10 SMS Gateway

Send SMS from Oracle SQL (part 4/4)

This is the last video in this video series which shows how to connect Ozeki SMS Gateway and Oracle SQL database server for SMS messaging. See how to insert a simple row into the proper table, so Ozeki SMS Gateway can automatically send SMS messages to mobile phones.

Video content
1. Execute SQL command
2. Check sent message

Look at the upcoming screenshots to thoroughly examine the final stage, which is SMS sending.

To test your system, you could send a test message directly from the Ozeki SMS Gateway. The first step, is to look at Figure 1. There you can see a code snippet copied into the field, where you can execute SQL Statements from. We provide you a copiable code for you, which you need to paste into the field and execute it. You could modify the code by typing a different phone number into the VALUE statement, or even a different message. It will send it to your chosen phone number.

INSERT INTO ozekimessageout (receiver, msg, status) VALUES ('+447951234567', 'test','send')

use insert statement to send message
Figure 1 - Use INSERT statement to send message

After you executed the statement, you could check your outgoing messages. You will see the test message there. You can see our example test message is sent, on Figure 2. You can see the phone number of the receiver, the creation time of the message and the sender’s address here.

the sent folder stores each sent message with details
Figure 2 - The Sent folder stores each sent message with details

More information