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

[Martin.Gruber1 at infineon.com]

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:henning.westerholt at 1und1.de]
Sent: Tuesday, July 31, 2007 4:37 PM
To: devel at openser.org; Gruber Martin (IFKL IT OS NV)
Subject: Re: [OpenSER-Devel] ORACLE-INSERT-Location-table

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,receiv
> ed ,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