|
|
Re: Windows Eventlog from triggered Oracle Stored Proc [message #343296 is a reply to message #340822] |
Tue, 26 August 2008 19:38 |
|
Kevin Meade
Messages: 2103 Registered: December 1999 Location: Connecticut USA
|
Senior Member |
|
|
Still, there might be a way, though it will require considerable work, unless someone has already done it all for us. Consider this:
Windows Event Log
most noteably
Quote: | Windows Event Log is designed for use by C/C++ programmers.
|
Next have a look at this:
Write Message to system event log
Wherein the author has a tutorial for C/C++. He shows how to write to the event log, read the event log, etc.
We all know it is possible to write plsql functions/procedure that can map to C++ and JAVA routines. So if you are willing to put out the effort, you can roll your own way to a pl/sql api that will write to the event log using the windows sdk.
It won't be easy. And it might be worth a call to both Oracle Support, and Microsoft Support to see if in fact this has already been done. Additionally you might wish to consult with someone about the possible problems you could be faced with in doing this (though I have no clue whom to ask).
Good luck, if you take this on, don't call us, we'll call you; but be sure to post your code if you build a working solution. Kevin
|
|
|