Re: ORA-01801 in log mining problem

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 24 Jan 2006 20:24:55 +0100
Message-ID: <dr5u88$fss$2@news3.zwoll1.ov.home.nl>

jbl wrote:
> Hi,
>
> I'm using LogMining in 10.1.0.400 database with Oracle.DataAccess.Client.
>
> What might cause the following error:
>
> Oracle.DataAccess.Client.OracleException ORA-01801: date format is too long
> for internal buffer at
> Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode,
> OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object
> src, String procedure)
> at Oracle.DataAccess.Client.OracleDataReader.Read()
>
> I have session settings:
>
> ALTER SESSION SET NLS_DATE_FORMAT = 'RRRRMMDDHH24MISS'
Odd format: RR is the "century-guessing-mode" of YY, so I cannot imagine what RRRR would be...

Maybe supported, maybe not, but I would go for YYYY.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Tue Jan 24 2006 - 13:24:55 CST