Thank, Nicko,
It works when using "String" in <param name="DbType" ... /> and removing <param name="Size" ... / >.
Thanks again.
Ping Xie
CACI
4831 Walden Lane
Lanham, MD 20706
[EMAIL PROTECTED]
(301) 306-8200 - Main
(301) 306-2829 - Direct
| "Nicko Cadell"
<[EMAIL PROTECTED]>
02/17/2005 01:03 PM
|
|
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
>
>
>
