Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ora-01843 client problem
hi,
i ran the application with odbc in trace mode. below is the section of code which raised the error.
i think the problem may lie with the nls settings on the database. i'm going to keep looking into the problem and will post my findings here. i'd appreciate any hints and tips people could offer.
TestApp - 514-78 ENTER SQLExecDirect HSTMT 01902D28 UCHAR * 0x01C589F0 [ -3] "INSERT INTOlogTable(historyID, userID, activityID, description, dateTime) values('040128000053', 1, 11,'TestApp Application accessed', to_date('28-Jan-2004 17:00:38', 'dd-Mon-yyyy hh24:mi:ss'))\ 0"
SDWORD -3 TAFilterSvr 3cc-4a8 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS) HSTMT 00F346E0 UWORD 1 UCHAR * 0x0135DDF0 [ 7] "userID" SWORD 256 SWORD * 0x01E5FCD6 (7) SWORD * 0x0192A300 (3) SQLLEN * 0x0192A304 (6) SWORD * 0x0192A308 (0) SWORD * 0x0192A30A (0) TestApp - 514-78 EXIT SQLExecDirect with return code -1 (SQL_ERROR) HSTMT 01902D28 UCHAR * 0x01C589F0 [ -3] "INSERT INTOlogTable(historyID, userID, activityID, description, dateTime) values('040128000053', 1, 11,'TestApp Application accessed', to_date('28-Jan-2004 17:00:38', 'dd-Mon-yyyy hh24:mi:ss'))\ 0"
SDWORD -3 DIAG [S1000] [Oracle][ODBC][Ora]ORA-01843: mes no válido(1843)