[SR-Users] Kamailio and Oracle database

[Daniel-Constantin Mierla]

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 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...
>
>
>
Does oracle support replace sql statement?

Cheers,
Daniel

-- 
Daniel-Constantin Mierla
http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, Berlin, May 18-20, 2016 - http://www.kamailioworld.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20160503/e6c19091/attachment.html>