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,received
> ,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
