Ozeki NG SMS Gateway logo OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"
info@ozeki.hu
SMS Gateway to send SMS via GSM modem or IP SMS connection Overview SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Quick start SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Download SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Manual SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection How to buy SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection FAQ SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Contact Us SMS Gateway to send SMS via GSM modem or IP SMS connection
OZEKI NG SMS Gateway - Product Guide

System database Contents | SearchMSSQL 2008

Home > Product Manual > Installation Guide > Installation Steps > System database > Oracle configuration

SMS Gateway SMS Gateway Home

  Product Manual
  Introduction
  SMS technology
  Installation Guide
  Prerequisites
  Download Information
  Installation Steps
  System database
  Oracle configuration
  MSSQL 2008
  MSSQL 2012/2014
  MySQL configuration
  Import messages
  Switch from file
  HTTPS
  Firewall on Windows 7
  Firewall on Windows 8
  Firewall on Windows 10
  Service Provider Connections
  Users and applications
  Linux
  User Guide
  Developers Guide
  Examples and Solutions
  Appendix
  FAQ
  Feature list
  Commercial Information
  Search
 


Automated phone calls?
Ozeki Phone System XE VoIP PBX software is an advanced PBX built for automated voice calls and 2 way SMS messaging. It has outstanding APIs for software developers. It can be used for:

Phone calls from SQL
Phone calls from HTTP
Voice and SMS applications

Callcenter developers
If you are working on telephone solutions, please check out the Ozeki VoIP SIP SDK.
It can be used to create VoIP client and server software.

Contact Us!
If you wish to get further information, do not hesitate to contact us!

E-mail: info@ozekisms.com

If you have a technical question, please submit a support request on-line.

System database configuration in Oracle

In case you need to store great numbers of SMS text messages it is possible that your system will be slowed down by this amount of stored files. By default, Ozeki NG SMS Gateway stores messages in files. In this way, it is highly recommended to use the System Database option in Ozeki NG SMS Gateway. This option allows you to speed up message sending. On this webpage you find a detailed configuration guide for using System Database with Oracle.

Please note!!!

When you switch to System Database, you need to restart the Ozeki NG service. After this, it is possible that you receive an error message since the system cannot find messages.
The reason for this: the system still searches for messages the file but system database stores them in a database. To avoid this error message please read How to import messages to System Database and How to switch from file to database sections.

Configuration steps

Go to Edit menu and select Server preferences menu item. Select Databases tab and click on System database settings tab. Here, enable Use a database server instead of file system to store messages. Database connection type needs to be set to OleDb. (Figure 1)

Provide your Connection string to the database. e.g.:
Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=admin;Password=qwe123


Figure 1 - System database settings

After this, provide the SQL statement for each tab:

Create tab:
DECLARE N NUMBER;BEGIN SELECT COUNT(*) INTO N FROM ALL_TABLES WHERE
TABLE_NAME='$utablename';IF N = 0 THEN EXECUTE IMMEDIATE 'CREATE TABLE
"$utablename" (MESSAGEID VARCHAR(60) DEFAULT NULL,CREATEDATE
VARCHAR(100) DEFAULT SYSDATE,SERIALIZEDMESSAGE CLOB DEFAULT NULL)'
;END
IF;END;
 

Load index tab:
SELECT MESSAGEID FROM "$utablename"

Load tab:
SELECT MESSAGEID,SERIALIZEDMESSAGE FROM "$utablename" WHERE MESSAGEID IN ($idlist)

Save tab:
DECLARE vClobVal VARCHAR2(32767) := '$serializedmessage';BEGIN INSERT
INTO "$utablename" (MESSAGEID,SERIALIZEDMESSAGE) VALUES ('$messageid',
vClobVal);END;
 

Delete tab:
DELETE FROM "$utablename" WHERE MESSAGEID IN ($idlist)

Move tab:
INSERT INTO "$utablename" (MESSAGEID, CREATEDATE,SERIALIZEDMESSAGE)
SELECT MESSAGEID, CREATEDATE, SERIALIZEDMESSAGE FROM "$usourcetable"
WHERE MESSAGEID IN ($idlist)

Find old tab:
SELECT MESSAGEID FROM "$utablename" WHERE
CREATEDATE<DATEADD(second,-$maxage, getdate())

Delete old tab:
DELETE FROM "$utablename" WHERE CREATEDATE<DATEADD(second,-$maxage,
getdate())

Update tab:
DECLARE vClobVal VARCHAR2(32767) := '$serializedmessage';BEGIN UPDATE
"$utablename" SET SERIALIZEDMESSAGE=vClobVal WHERE
MESSAGEID='$messageid';END;
 




Next page: MSSQL 2008
Copyright © 2000- - Ozeki Ltd | info@ozeki.hu
Home > Product Manual > Installation Guide > Installation Steps > System database > Oracle configuration
Legal | Privacy policy | Terms of use
Page: 2726 | Login | 54.91.4.56