.... i m an pl/sql developer

working for a coperative banks

now the bank pepoles want to send sms to their customer when they do some transaction

whether it is credited or debited

.. bank is using a oracle database to store the information

about all transaction and using window OS

after every transaction it insert a row in a dotr010 (transaction table)

sir i had developed a standalone software to send sms usning AT commands in VB 6.0

but sir it is not automatically trigger a sms to customer this utility not send sms untill it is not run by bank pepoles

i need your help

my banking software is completely

window based

i need ur help to get know

1. how to communicate GSM modem through oracle (procedure,pl/sql)

2. how the sms is triggered when one row is inserted in a transaction tabel

3. and how to maintain log file

this all only by using oracle no interface

thanks for kind time

i hope you pepole reply soon

i need it

regard

atul