Hello,
On 02/05/16 15:25, gmele wrote:
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.
OK, good to know -- perhaps we have to change the definition for oracle sql scripts.
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@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...
Does oracle support replace sql statement?
Cheers, Daniel