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

[Martin.Gruber1 at infineon.com]

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?

Regards

Martin