[OpenSER-Devel] Again Oracle problems

[Victor Gamov]

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

Hi again :-)

> 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?

OpenSER  hasn't native Oracle connector so IIUC you connect to Oracle 
using ODBC.

when module (usrloc, registrar or some other) tries to insert data into 
DB it convert current timestamp into DATETIME format. But Oracle don't 
understand it. On other habd if you use ODBC then it's may be correct 
way to fix this conversion in unixodbc module to use ODBC-like "escaped 
DATETIME format". As I red it will be understand by Oracle correctly.

But I haven't Oracle DB access. So needs to tests.

Any comments from other Oracle guru ?

P.S. Martin, you can post your question into users-list. I think 
somebody use Oracle in production.

-- 
CU,
Victor Gamov