trigger to call a batch file [message #233329] |
Wed, 25 April 2007 13:13  |
Arpit
Messages: 99 Registered: March 2001
|
Member |
|
|
Hi there,
Can I create a db trigger on a table to invoke a batch file (.vbs) file when a date field on that table gets updated?
Please advice.
Thanks very much,
|
|
|
|
|
Re: trigger to call a batch file [message #233333 is a reply to message #233332] |
Wed, 25 April 2007 13:27  |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
It is not an easy task to call something non-Oracle from Oracle.
It tooks days of work to debug such code.
I will surely not do it here for you.
Now, all I can tell you is you can do it.
Search on AskTom how to call OS command from PL/SQL.
Study documentation to know how to code triggers.
Search on AskTom how to asynchroneously call a procedure (if you don't want to block your DML with an external program). You can also study dbms_job package.
With that, you have all the elements to do what you want.
Regards
Michel
|
|
|