[SR-Users] Kamailio and Oracle database

[gmele]

Hello Daniel,

I found the problem: kamctl tool for oracle created a BLOB for the BODY
column of table PRESENTITY.

I changed it to CLOB and now it works better. I still have some errors in a
query to replace watchers (see below). I'm trying to investigate the problem
before boring you with that.

Here is the the error I get:

Query= replace
watchers(presentity_uri,watcher_username,watcher_domain,event,status,inserted_time,reason
) values
('sip:frederic.mathys at ims-nagra.test','giovanni.mele','ims-nagra.test','presence',1,1462195290,'')

May  2 15:21:30 newvm1 /usr/sbin/kamailio[560]: ERROR: db_unixodbc
[connection.c:220]: db_unixodbc_extract_error():
unixodbc:SQLExecDirect=42000:1:900:[Oracle][ODBC][Ora]ORA-00900: invalid SQL
statement#012

I fail to understand where is the where clause of the replace query...


Regards


Giovanni




--
View this message in context: http://sip-router.1086192.n5.nabble.com/Kamailio-and-Oracle-database-tp147990p148033.html
Sent from the Users mailing list archive at Nabble.com.