[OpenSER-Devel] Again Oracle problems

Martin.Gruber1 at infineon.com Martin.Gruber1 at infineon.com
Tue Aug 7 10:50:24 CEST 2007


Hi,

Thanks for your reply. In Oracle you do not have the DATETIME format. I
use libsqora.so.10.1.
I thinks the insert string is in the usrloc Module, not in the unixodbc
module, or am I false?

Kind regards

martin 

-----Original Message-----
From: devel-bounces at openser.org [mailto:devel-bounces at openser.org] On
Behalf Of Victor Gamov
Sent: Monday, August 06, 2007 8:48 PM
To: devel at openser.org
Subject: Re: [OpenSER-Devel] Again Oracle problems

Martin.Gruber1 at infineon.com wrote:
> Hi @ all,

Hi Martin!

> I have set up my Oracle DB together with OpenSER. It is running well, 
> but I have problems with inserting Data from usrloc. The dateformat is

> like this: YYYY-MM-DD HH:MM:SS from OpenSER but my DB "wants" it Like 
> this: DD-MM-YYYY HH:MM:SS Does anybody know how to set it up in ORACLE

> to run well. I tried it with alter session set nls_date_format = 
> 'YYYY-MM-DD'; But it is not running!
> 
> I do not want to change it in the module, as I always have to change 
> it, after an update or newer version!

YYYY-MM-DD HH:MM:SS is ODBC-like DATETIME format. If I understand
correctly you must set DB-specific datetime format in Oracle driver
config (it it possible to you driver)

Also it may be possible to update unixodbc module to use "escaped ODBC
DATETIME format" like this {ts 'yyyy-mm-dd hh:mm:ss'} (see at
http://msdn2.microsoft.com/en-us/library/ms190234.aspx)

Needs to test.


--
CU,
Victor Gamov

_______________________________________________
Devel mailing list
Devel at openser.org
http://openser.org/cgi-bin/mailman/listinfo/devel



More information about the Devel mailing list