Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-01801 in log mining problem

ORA-01801 in log mining problem

From: jbl <jarmo.blomsterN0SPM_at_ccc.fi>
Date: Tue, 24 Jan 2006 14:09:27 GMT
Message-ID: <ryqBf.163$K27.16@read3.inet.fi>


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                                                AMERICAN
NLS_CHARACTERSET
WE8ISO8859P1
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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US