Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> ORA-01801 in log mining problem
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' ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'RRRRMMDDHH24MISS.FF' ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT = 'RRRRMMDDHH24MISS.FFTZH:TZM' query:
select * from v$NLS_PARAMETERS
returns:
NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-Mon-RRRR NLS_DATE_LANGUAGE AMERICANNLS_CHARACTERSET
NLS_SORT BINARY NLS_TIME_FORMAT HH.MI.SSXFF AM NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR NLS_DUAL_CURRENCY $ NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_COMP BINARY NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CONV_EXCP FALSE
//Jarmo Received on Tue Jan 24 2006 - 08:09:27 CST
![]() |
![]() |