<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><SPAN style="font-size:10pt;">Hi,</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">This is the structure of my location table.</SPAN></div>
<div><SPAN style="font-size:10pt;">If you need any information please let me know..</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">Thanks for your help in advanced</SPAN></div>
<div> </div>
<div><SPAN style="font-size:10pt;">Regards</SPAN></div>
<div><SPAN style="font-size:10pt;">Tung<br /><br /></span></div>
<div><SPAN style="font-size:10pt;color:navy;">> Hi,</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> please send me the structure of your location table.</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> regards</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> martin</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> From: Tung Tran [<a href="mailto:tr.tung@gmail.com]">mailto:tr.tung@gmail.com]</a></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Sent: Wednesday, October 03, 2007 8:55 AM</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> To: Gruber Martin (IFKL IT OS NV)</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Cc: users@openser.org</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Subject: RE: [OpenSER-Users] Error when connect to Oracle via ODBC.</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Dear Martin,</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> I am using Openser 1.2.2 and the odbc lib is libsqora.so.10.1 I</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> also follow the guide on web to batch the unixodbc module and it</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> runs with the error I just report.</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> (<a href="http://openser.org/pipermail/users/2007-August/012532.html">http://openser.org/pipermail/users/2007-August/012532.html</a>)</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Please help,</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Regards</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">> Tung</SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:navy;">></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Hi,</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> what version of OpenSER do you use. Seems that something in the</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> source is not running well. Check out the newest version first.</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> If it is not the case let me know!</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> regards</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Martin</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> From: users-bounces@openser.org [<a href="mailto:users">mailto:users</a>-</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> bounces@openser.org] On Behalf Of Tung Tran Sent: Wednesday,</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> October 03, 2007 7:18 AM To: users@openser.org</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Subject: [OpenSER-Users] Error when connect to Oracle via ODBC.</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Hi all,</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> I am trying to connect Openser with Oracle via odbc. So far I can</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> connect sucessfully to Oracle DB via unixODBC module, I can</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> register and make call,</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> However I got this error from Openser debug that I dont know it</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> may effect to Openser operation</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> 1(9499) unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>>  00920: invalid relational operator</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> 1(9499) unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>>  00920: invalid relational operator</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> 1(9499) db_raw_query: Error while submitting query  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> ERROR:usrloc:get_all_db_ucontacts: raw_query failed  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> unixodbc:SQLExecDirect, rv=100. Query= delete from location where</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> expires</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> expires!=to_date('1970-01-0107:00:00','YYYY-MM-DD HH24:MI:SS')  </SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> 1(9499) unixodbc:SQLExecDirect, rv=-1. Query= select received,</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> contact, socket, cflags from location where expires > now() and</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> cflags & 64 = 64  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> invalid relational operator    1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> invalid relational operator  </SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> 1(9499) db_raw_query: Error while submitting query  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> ERROR:usrloc:get_all_db_ucontacts: raw_query failed  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> unixodbc:SQLExecDirect, rv=-1. Query= select received, contact,</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> socket, cflags from location where expires > now() and cflags &</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> 64 = 64  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> invalid relational operator    1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> invalid relational operator  </SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> 1(9499) db_raw_query: Error while submitting query  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> ERROR:usrloc:get_all_db_ucontacts: raw_query failed  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> unixodbc:SQLExecDirect, rv=-1. Query= select received, contact,</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> socket, cflags from location where expires > now() and cflags &</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> 64 = 64  1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> unixodbc:SQLExecDirect=HY000:1:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> invalid relational operator    1(9499)</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> unixodbc:SQLExecDirect=HY000:2:920:[Oracle][ODBC][Ora]ORA-00920:</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> invalid relational operator    </SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Should anyone sucess customize Openser to work smoothly with</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Oracle? please help.</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>></SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Thanks and regards</SPAN></div>
<div><SPAN style="font-size:10pt;color:maroon;">>> Tung</SPAN></div>
</body></html>