SQL & PL/SQL

i had seen the article Send Message From Oracle To Mobile Device here


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
after every transaction it insert a row in a dotr010 (transaction table)

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 help from u ppl
my banking software is completely
window based

i need help from u ppl 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

regard
atul