Home » Infrastructure » Windows » Windows Eventlog from triggered Oracle Stored Proc (10g r2)
Windows Eventlog from triggered Oracle Stored Proc [message #340822] Thu, 14 August 2008 08:52 Go to next message
lancelotlinc
Messages: 1
Registered: August 2008
Junior Member
Could someone please post a method to insert an event into the Windows eventlog from a triggered Stored Proc? sys.dbms_system.ksdwrt is not sufficient.

TIA
Re: Windows Eventlog from triggered Oracle Stored Proc [message #340829 is a reply to message #340822] Thu, 14 August 2008 09:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is none.

Regards
Michel
Re: Windows Eventlog from triggered Oracle Stored Proc [message #343296 is a reply to message #340822] Tue, 26 August 2008 19:38 Go to previous message
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
Previous Topic: Error oui-10133
Next Topic: Problem upgrading 9.2.0.5 to 9.2.0.7
Goto Forum:
  


Current Time: Fri Mar 29 08:28:48 CDT 2024