|
|
Re: Running a batch file from oracle [message #388662 is a reply to message #388109] |
Wed, 25 February 2009 21:16  |
 |
Kevin Meade
Messages: 2103 Registered: December 1999 Location: Connecticut USA
|
Senior Member |
|
|
as long as your privileges are good, you can drop out to the OS to call just about anything. Thus whatever you can do from the OS (more or less) you can do from inside oracle by doing a callout.
Do some googling for how to execute OS commands from the database. I seem to recall someone had a java program that did it. This was many years ago I saw it. Who knows, by now maybe oracle has a database package to support it.
However, you will find that if this is for a business with a strong DBA staff, they will likely frown heavily upon this practice. In particular they will reference security concerns so in the end, once you work through all the details, you may get blocked anyway. I suggest you ask first before you spend a good deal of your time on it.
Additionally you may find that the methods used to access the OS are not always portable. Different OS, different method. Thus for examples, doing same on WINDOWS NT might require use of a DLL file but on WINDOWS 2000, a different DLL, and on Unix something else entirely. Your code may need to be environment aware and this is not good. Most of us are not doing govenment work.
Good luck, Kevin
|
|
|