Gammu is one of free sms gateway that easily to use.
Basic idea is gammu using mysql(Xampp) and
we can remote xmapp using oracle DB10g usnig DBLink
Bridging gammu sms center with oracle DB 10g
Gammu is one of free sms gateway that easily to use.
Basic idea is gammu using mysql(Xampp) and
we can remote xmapp using oracle DB10g usnig DBLink
How to configure Gammu using Modem Wavecomm Fastrack M1306B
Basic tools
Win7
Gammu 1.33.0
Modem waveCOM M1306B
Let's Begin
Download waveCom M136B Driver hereDownload Gammu 1.33.0 here
How to Configure Gammu and wavecom
1.
First, you need to make sure to connect modem and your computer properlyfind your modem port COM1,COM2,COM3 etc on Device Manager
2.
Extract Gammu on what ever you want, in my case i placed gammu on drive C:\gammuif gammu does not work properly
find this file libiconv-2.dll and copy on C:\windows\system32
3.
setting 2 file bellow gammurc for checking your phone connect properly with gammuand smsdrc for connecting gammu sms with mysql
C:\gammu\bin\gammurc
[gammu]device = com3:
connection = at115200
use gammu --identify for checking connection
gammu --identify
it looks work good then
create user a password a database a on mysql using this file
C:\gammu\share\doc\gammu\examples\sql\mysql.sql
C:\gammu\bin\smsdrc
[gammu]port = com3:
connection = at115200
[smsd]
service = mysql
logfile =smdlog
debuglevel = 0
PIN = 1234
user = a
password = a
pc = localhost
database = a
you need to use bellow command to install service uninstall start and stop
note : every single change on smsdrc file, you need to re-create service gammu (un install and install service)
gammu-smsd.exe -c smsdrc -i (install service)
gammu-smsd.exe -c smsdrc -u (uninstall service)
gammu-smsd.exe -c smsdrc -s (start service)
gammu-smsd.exe -c smsdrc -k (stop service)
Testing send sms
smsdrc sendsms TEXT 0878xxxxxxxx -text “smsok!"note : sometimes you can't send message because the number 0 and change it +62 depend on your country code
if you find error 500 on gammu
1.check the smsdrc file
2.recreate service
3.check the signal
4.check your debit
5.check the modem ( it can.t detect with out simcard)
6.you cant use smsdrc sendsms TEXT if the service is running (stop the service and run the command)
done!
source :#https://adityasasongko.wordpress.com/2013/07/21/konfigurasi-gammu-menggunakan-modem-wavecomm-fastrack-m1306b/
#http://www.yusiwa.com/download-software-sms/download-driver-modem/
Convert comma separated string to array in pl sql or vice versa aka Array on oracle 10g
Hi there now day i have a little problem with my documentations.
i rarely noted my work and then when the case came my head is exploding.
before it came too late i wanna note this my experiences about Convert comma separated string to array in pl sql or vice versa.
First Case
I have simple query A,B,C,D and i would like to return the results in one row, like this
XXX
------------
A
B
C
D
f_convert
/* Create the output TYPE, here using a VARCHAR2(100) nested table type */SQL> CREATE TYPE test_type AS TABLE OF VARCHAR2(100);
/
Type created.
/* Now, create the function.*/
SQL> CREATE OR REPLACE FUNCTION f_convert(p_list IN VARCHAR2)
RETURN test_type
AS
l_string VARCHAR2(32767) := p_list || ',';
l_comma_index PLS_INTEGER;
l_index PLS_INTEGER := 1;
l_tab test_type := test_type();
BEGIN
LOOP
l_comma_index := INSTR(l_string, ',', l_index);
EXIT WHEN l_comma_index = 0;
l_tab.EXTEND;
l_tab(l_tab.COUNT) := SUBSTR(l_string, l_index, l_comma_index - l_index);
l_index := l_comma_index + 1;
END LOOP;
RETURN l_tab;
END f_convert;
/
Function created.
/* Prove it works */
SQL> SELECT * FROM TABLE(f_convert('A,B,C,D'));
COLUMN_VALUE
--------------------------------------------------------------------------------
A
B
C
D
Second Case
i haveXXX
------------
A
B
C
D
and i would like to return the result like A,B,C,D
String agg
1.
CREATE OR REPLACE TYPE t_string_agg AS OBJECT(
g_string VARCHAR2(32767),
STATIC FUNCTION ODCIAggregateInitialize(sctx IN OUT t_string_agg)
RETURN NUMBER,
MEMBER FUNCTION ODCIAggregateIterate(self IN OUT t_string_agg,
value IN VARCHAR2 )
RETURN NUMBER,
MEMBER FUNCTION ODCIAggregateTerminate(self IN t_string_agg,
returnValue OUT VARCHAR2,
flags IN NUMBER)
RETURN NUMBER,
MEMBER FUNCTION ODCIAggregateMerge(self IN OUT t_string_agg,
ctx2 IN t_string_agg)
RETURN NUMBER
);
/
SHOW ERRORS
2.
CREATE OR REPLACE TYPE BODY t_string_agg ISSTATIC FUNCTION ODCIAggregateInitialize(sctx IN OUT t_string_agg)
RETURN NUMBER IS
BEGIN
sctx := t_string_agg(NULL);
RETURN ODCIConst.Success;
END;
MEMBER FUNCTION ODCIAggregateIterate(self IN OUT t_string_agg,
value IN VARCHAR2 )
RETURN NUMBER IS
BEGIN
SELF.g_string := self.g_string || ',' || value;
RETURN ODCIConst.Success;
END;
MEMBER FUNCTION ODCIAggregateTerminate(self IN t_string_agg,
returnValue OUT VARCHAR2,
flags IN NUMBER)
RETURN NUMBER IS
BEGIN
returnValue := RTRIM(LTRIM(SELF.g_string, ','), ',');
RETURN ODCIConst.Success;
END;
MEMBER FUNCTION ODCIAggregateMerge(self IN OUT t_string_agg,
ctx2 IN t_string_agg)
RETURN NUMBER IS
BEGIN
SELF.g_string := SELF.g_string || ',' || ctx2.g_string;
RETURN ODCIConst.Success;
END;
END;
/
SHOW ERRORS
3.
CREATE OR REPLACE FUNCTION string_agg (p_input VARCHAR2)RETURN VARCHAR2
PARALLEL_ENABLE AGGREGATE USING t_string_agg;
/
SHOW ERRORS
How to use
select string_AGG(X) from xxx
Done!
source :Comma to array
#http://stackoverflow.com/questions/3819375/convert-comma-separated-string-to-array-in-pl-sql
#
http://stackoverflow.com/questions/468990/how-can-i-combine-multiple-rows-into-a-comma-delimited-list-in-oracle
String_agg (arry to comma)
#https://oracle-base.com/articles/misc/string-aggregation-techniques
How to install Java 6 (6u27) on your browser Firefox Ubuntu
https://ubuntuforums.org/showthread.php?t=1904467
Internet explorer stopped working when opening oracle forms 10g windows7
Basically , When U run oracle forms 10g and it shows blank or Stop working on your browser, because Jinit on oracle 10g is not support on that browser. . .
I googled a little and found those problems. . .
Now i will share U how to work your oracle form 10g on your PC
Basic OS
*Win7
*Oracle Developer 10g
*Java Runtime 6u27
source : https://www.youtube.com/watch?v=lzyHQ2PcWHI
I googled a little and found those problems. . .
Now i will share U how to work your oracle form 10g on your PC
Basic OS
*Win7
*Oracle Developer 10g
*Java Runtime 6u27
The Idea is finding How to Run oracle form 10g in Mozilla or Any browser
1.
Install Java Environment
2.
Change The Formsweb.cfg
3.
Add the plugin in browser
source : https://www.youtube.com/watch?v=lzyHQ2PcWHI
How to install oracle developer suite 10g on windows 7
 |
| How to install oracle developer suite 10g on windows 7 |
Actually, I have a little bit problem when i try to install oracle developer suite 10g.
I found error that my system does not support, but now i found the solutions.
It needs a little tricks that will decoy Oracle Standard system required.
Come Let 's Start
1.
Go to "oracle developer suite 10g Installer Folder"\Install\oraparam.ini
2.
Find :[Certified Versions]Add this script :
Windows=5.0,5.1,5.2
Solaris=5.8,5.9
Linux=redhat-2.1AS
HPUX=B.11.11
[Certified Versions]
Windows=5.0,5.1,5.2,4.1
Solaris=5.8,5.9
Linux=redhat-2.1AS
HPUX=B.11.11
Find :
[Windows-5.1-required]Edit :
#Minimum display colours for OUI to run
MIN_DISPLAY_COLORS=256
SWAP_SPACE=1535
TEMP_SPACE=150
[Windows-6.1-required]Save and exit file.
#Minimum display colours for OUI to run
MIN_DISPLAY_COLORS=256
SWAP_SPACE=1535
TEMP_SPACE=150
3.
Add Virtual memory sizeGo To Advanced system settings >>Tab " Advanced ">>Button Performance's "Setting">>Tab " Advanced ">>Button "Change"
Initial size = 4000
Max size = 4000
Ok and restart your PC.
 |
4.
Go to "oracle developer suite 10g Installer FolderSet Property file Compatibility as "Windows XP Console Pack 2"
5.
Run Setup
6.
Done!#Source : https://www.youtube.com/watch?v=qYeic14YK-Y
Langganan:
Postingan (Atom)