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 NG SMS Gateway

How to test your oracle connection

After you have successfully configured your Oracle database link, you might want to send several test SMS messages to test the functionality and the performance of Ozeki SMS Gateway. To do this you may use the following SQL query in Oracle.

How to send text messages from Oracle in a loop

In order to send several SMS messagse for testing, the best option is to write a loop in Oracle that will insert multiple records into the outgoing SMS table. To write a loop, you need to use the BEGIN and END commands and use teh FOR IN LOOP statements. Take a look at the following example:

BEGIN
    FOR v_LoopCounter IN 1..1000 LOOP
	  INSERT INTO ozekimessageout (receiver, msg, status) 
	  VALUES ('+36209355418', concat('test',TO_CHAR(v_LoopCounter)), 'send');
        COMMIT;
    END LOOP;
END;

More information