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 -> Re: ora-01843 client problem

Re: ora-01843 client problem

From: championsleeper <strepxe_at_yahoo.co.uk>
Date: 29 Jan 2004 06:57:29 -0800
Message-ID: <103a78f3.0401290657.6b2e7eee@posting.google.com>


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 INTO
logTable(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 INTO
logTable(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)
Received on Thu Jan 29 2004 - 08:57:29 CST

Original text of this message

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