[OpenSER-Devel] ORACLE-INSERT-Location-table

[Henning Westerholt]

On Tuesday 31 July 2007, Martin.Gruber1 at infineon.com 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:1004 at xxx.xx.xxx.xxx:2419;line=1orbynh2','2007-06-24
> 10:05:56',0.50
> ,'3c27ad980000-9cc0ywsv8ei9 at snom320-00041324AA77',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