Well I insert that sql statement in my oracle client and it is running well. So I do not think that the format is wrong........
-----Original Message----- From: Henning Westerholt [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 31, 2007 4:37 PM To: devel@openser.org; Gruber Martin (IFKL IT OS NV) Subject: Re: [OpenSER-Devel] ORACLE-INSERT-Location-table On Tuesday 31 July 2007, [EMAIL PROTECTED] wrote: > HI, > > I have troubles openser sending database insert statement to ORACLE. > insert into location > (username,contact,expires,q,callid,cseq,flags,cflags,user_agent,receiv > ed ,path,socket,methods,last_modified ) values > ('1004','sip:[EMAIL PROTECTED]:2419;line=1orbynh2','2007-06-24 > 10:05:56',0.50 > ,'[EMAIL PROTECTED]',584,0,0,'snom320/6.2 > .3 > ',NULL,NULL,'udp:xxx.xx.xxx.xx:5060',7999,'2007-06-24 09:55:56') > 1(19588) > unixodbc:SQLExecDirect=HY000:1:1861:[Oracle][ODBC][Ora]ORA-01861: > literal does not match format string > > When I insert that statement in ORACLE-client it is running well and I > think it has something to do with the timeformat. > Does somebody know that error? Hello Martin, http://www.google.de/search?q=ORA-01861%3A+literal+does+not+match+format +string&ie=UTF-8&oe=UTF-8 :-) Yes, its an error regarding the date format. The length of the date is perhaps different than expected, or the format with the separators are different. As a short note, please, don't "hijack" a thread in the mailling list (with reply). If you have a question simply start a new e-mail. Thank you. Henning _______________________________________________ Devel mailing list Devel@openser.org http://openser.org/cgi-bin/mailman/listinfo/devel
