Hi,

what version of OpenSER do you use. Seems that something in the source is not running well. Check out the newest version first.

If it is not the case let me know!

regards

Martin

From: users-bounces@openser.org [mailto:users-bounces@openser.org] On Behalf Of Tung Tran
Sent: Wednesday, October 03, 2007 7:18 AM
To: users@openser.org
Subject: [OpenSER-Users] Error when connect to Oracle via ODBC.

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