Hi all,

I am trying to connect Openser with Oracle via odbc. So far I can connect sucessfully to Oracle DB via unixODBC module, I can register and make call,

However I got this error from Openser debug that I dont know it may effect to Openser operation

1(9499) unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: invalid relational operator

1(9499) unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920: invalid relational operator

1(9499) db_raw_query: Error while submitting query

1(9499) ERROR:usrloc:get_all_db_ucontacts: raw_query failed

1(9499) unixodbc:SQLExecDirect, rv=100. Query= delete from location where expires<to_date('2007-10-0307:53:20','YYYY-MM-DD HH24:MI:SS') AND expires!=to_date('1970-01-0107:00:00','YYYY-MM-DD HH24:MI:SS')

1(9499) unixodbc:SQLExecDirect, rv=-1. Query= select received, contact, socket, cflags from location where expires > now() and cflags & 64 = 64

1(9499) unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: invalid relational operator

1(9499) unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920: invalid relational operator

1(9499) db_raw_query: Error while submitting query

1(9499) ERROR:usrloc:get_all_db_ucontacts: raw_query failed

1(9499) unixodbc:SQLExecDirect, rv=-1. Query= select received, contact, socket, cflags from location where expires > now() and cflags & 64 = 64

1(9499) unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: invalid relational operator

1(9499) unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920: invalid relational operator

1(9499) db_raw_query: Error while submitting query

1(9499) ERROR:usrloc:get_all_db_ucontacts: raw_query failed

1(9499) unixodbc:SQLExecDirect, rv=-1. Query= select received, contact, socket, cflags from location where expires > now() and cflags & 64 = 64

1(9499) unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: invalid relational operator

1(9499) unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920: invalid relational operator

Should anyone sucess customize Openser to work smoothly with Oracle? please help.

Thanks and regards

Tung