<html><head><meta name="Generator" content="PSI HTML/CSS Generator"/>
<style type="text/css"><!--
body{font-family:'Tahoma';font-size:10pt;font-color:'#000000';}
LI{display:list-item;margin:0.00in;}
p{display:block;margin:0.00in;}
body{}
--></style>
</head><BODY ><div> </div>
<div><SPAN style="font-family:'Arial';font-size:10pt;">Hi all,</SPAN></div>
<div> </div>
<div><SPAN style="font-family:'Arial';font-size:10pt;">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,</SPAN></div>
<div><SPAN style="font-family:'Arial';font-size:10pt;">However I got this error from Openser debug that I dont know it may effect to Openser operation </SPAN></div>
<div> </div>
<div><SPAN style="font-family:'Arial';font-size:10pt;"> 1(9499) unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: invalid relational operator</SPAN></div>
<div> </div>
<div><SPAN style="font-family:'Arial';font-size:10pt;"> 1(9499) unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920: invalid relational operator</SPAN></div>
<div> </div>
<div><SPAN style="font-family:'Arial';font-size:10pt;"> 1(9499) db_raw_query: Error while submitting query</SPAN></div>
<div><SPAN style="font-family:'Arial';font-size:10pt;"> 1(9499) ERROR:usrloc:get_all_db_ucontacts: raw_query failed</SPAN></div>
<div><SPAN style="font-family:'Arial';font-size:10pt;"> 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')</SPAN></div>
<div><SPAN style="font-family:'Arial';font-size:10pt;"> 1(9499) unixodbc:SQLExecDirect, rv=-1. Query= select received, contact, socket, cflags from location where expires > now() and cflags & 64 = 64</SPAN></div>
<div><SPAN style="font-family:'Arial';font-size:10pt;"> 1(9499) unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: invalid relational operator</SPAN></div>
<div> </div>
<div><SPAN style="font-family:'Arial';font-size:10pt;"> 1(9499) unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920: invalid relational operator</SPAN></div>
<div> </div>
<div><SPAN style="font-family:'Arial';font-size:10pt;"> 1(9499) db_raw_query: Error while submitting query</SPAN></div>
<div><SPAN style="font-family:'Arial';font-size:10pt;"> 1(9499) ERROR:usrloc:get_all_db_ucontacts: raw_query failed</SPAN></div>
<div><SPAN style="font-family:'Arial';font-size:10pt;"> 1(9499) unixodbc:SQLExecDirect, rv=-1. Query= select received, contact, socket, cflags from location where expires > now() and cflags & 64 = 64</SPAN></div>
<div><SPAN style="font-family:'Arial';font-size:10pt;"> 1(9499) unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: invalid relational operator</SPAN></div>
<div> </div>
<div><SPAN style="font-family:'Arial';font-size:10pt;"> 1(9499) unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920: invalid relational operator</SPAN></div>
<div> </div>
<div><SPAN style="font-family:'Arial';font-size:10pt;"> 1(9499) db_raw_query: Error while submitting query</SPAN></div>
<div><SPAN style="font-family:'Arial';font-size:10pt;"> 1(9499) ERROR:usrloc:get_all_db_ucontacts: raw_query failed</SPAN></div>
<div><SPAN style="font-family:'Arial';font-size:10pt;"> 1(9499) unixodbc:SQLExecDirect, rv=-1. Query= select received, contact, socket, cflags from location where expires > now() and cflags & 64 = 64</SPAN></div>
<div><SPAN style="font-family:'Arial';font-size:10pt;"> 1(9499) unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920: invalid relational operator</SPAN></div>
<div> </div>
<div><SPAN style="font-family:'Arial';font-size:10pt;"> 1(9499) unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920: invalid relational operator</SPAN></div>
<div> </div>
<div> </div>
<div><SPAN style="font-family:'Arial';font-size:10pt;">Should anyone sucess customize Openser to work smoothly with Oracle? please help.</SPAN></div>
<div> </div>
<div><SPAN style="font-family:'Arial';font-size:10pt;">Thanks and regards</SPAN></div>
<div><SPAN style="font-family:'Arial';font-size:10pt;">Tung</SPAN></div>
</body></html>