Logging to Oracle 10 database

Topics: Logging Application Block
Feb 10, 2008 at 7:32 PM
Hello

I am currently looking at the Enterprise Library for logging purposes and am having problems logging to Oracle Database. As this is the database of choise I have no other option regarding db-type (eg. MS-SQL).
With the includes db-scripts I have created the required tables and procedures. The configuration is set up to log both to flat file and database but it consistently throws exception "PLS-00306: wrong number or types of arguments in call to 'SP_WRITELOG'. When copying the code for procedure execution and 'manualy' run it using the ODP (Oracle.DataAccess.Client) the procedure runs correct but when run with the System.Data.OracleClient using the same parameter setup the procedure fails.

Anyone have experience with Logging to Oracle?
Feb 11, 2008 at 4:02 PM
Hi,

http://jopinblog.wordpress.com/2007/05/21/enterprise-library-logging-to-oracle-database/
Feb 12, 2008 at 6:50 AM

Hello

I have read this article but consider this as a 'last way out' solution. By implementing a custom extention I loose the functionality in the configuration tool as it does not seem to understand the config file with a non-EntLib assembly reference.
Jul 30, 2008 at 12:13 PM
Hi,

It seems that when you create  a custom trace listener that inherits from CustomTraceListener you are able to (after loading the assembly in the EntLib Config Tool) select the newly created custom trace listener.
Check this msdn site for an example:
http://msdn.microsoft.com/en-us/library/cc309289.aspx

The problem with the example created in this blog (http://jopinblog.wordpress.com/2007/05/21/enterprise-library-logging-to-oracle-database/) doesn't inherit/implement from it. Thus you cannot select it in the Config Tool.

Does anybody know a way around this?
I cannot believe that EntLib was programmed in a way so that you cannot use it to log to an Oracle database.

Thnx!!