Pass the name of the System.Data.DbType enum value that you would pass to the OracleParameter.DbType.OracleParameter.DbType for the prepared statement parameter.
I don't use Oracle but I would guess that String or AnsiString and Decimal are the values to use. Nicko > -----Original Message----- > From: Ping Xie [mailto:[EMAIL PROTECTED] > Sent: 17 February 2005 16:47 > To: Log4NET User > Cc: Log4NET User > Subject: Re: ADONetAppender > > > Sorry that I forgot to mention that I'm using ADONetAppender > to log to Oracle 9i database. In log4net configuration file, > there is a <param..>...</param> block for each database > column, something like listed below. > > <param name="Parameter"> > <param name="ParameterName" value=":thread" /> > <param name="DbType" value="String" /> > <param name="Size" value="255" /> > <param name="Layout" type="log4net.Layout.PatternLayout"> > <param name="ConversionPattern" value="%t" /> > </param> > </param> > > If I need to log to CLOB and NUMBER columns, what are the > values for the DbType and Size entries? > > Thank you. > > Ping Xie > > CACI > 4831 Walden Lane > Lanham, MD 20706 > [EMAIL PROTECTED] > (301) 306-8200 - Main > (301) 306-2829 - Direct > > > > > Ping Xie <[EMAIL PROTECTED]> > > 02/17/2005 07:41 AM > Please respond to > "Log4NET User" <[email protected]> > > To > "Log4NET User" <[email protected]> cc Subject > ADONetAppender > > > > > > > > Hi, > > If I want to write logging to a CLOB and NUMBER columns, how > should I define the parameters in the configuration file? > Specifically, what are the values in the following two lines? > > <param name="DbType" value="?????" /> > <param name="Size" value="????" /> > > Thank you in advance. > > Ping Xie > > CACI > 4831 Walden Lane > Lanham, MD 20706 > [EMAIL PROTECTED] > (301) 306-8200 - Main > (301) 306-2829 - Direct > > >
