Re: Toughie: Java Stored Procedure & SyslogAppender

On 10 Mar 2005 10:17:28 -0800, fahdshariff_at_yahoo.com wrote:

>Hello,
>
>I want Oracle to be able to send messages to syslog. So I thought of
>writing a Java program that uses the SyslogAppender class of Log4j to
>do this. This program works fine and messages are indeed written to
>syslog (and eventually picked up by Tivoli, our monitoring system).
>
>However, when I try to load the class and all associated jars into
>Oracle and then try running it, it doesnt work. No messages are output.
>
>Could it be that its just not possible to write to syslog from Oracle?
>
>I've even tried simple messages: log.fatal(mymessage); and it still
>doesnt work. I know that I have loaded everything needed; it compiles
>and no errors are output.
>
>Any ideas?

Why use Java? You don't need it as there is a C library routine to append to syslog, and you can call C programs from Oracle using the external procedure facility. Why use a resource hog, where you don't use any Java facilities at all?

--
Sybrand Bakker, Senior Oracle DBA