<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Hello,<br>
</p>
<br>
<div class="moz-cite-prefix">On 02/05/16 15:25, gmele wrote:<br>
</div>
<blockquote cite="mid:1462195551920-148033.post@n5.nabble.com"
type="cite">
<pre wrap="">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.</pre>
</blockquote>
OK, good to know -- perhaps we have to change the definition for
oracle sql scripts.<br>
<br>
<blockquote cite="mid:1462195551920-148033.post@n5.nabble.com"
type="cite">
<pre wrap=""> 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
('<a class="moz-txt-link-freetext" href="sip:frederic.mathys@ims-nagra.test','giovanni.mele','ims-nagra.test','presence',1,1462195290">sip:frederic.mathys@ims-nagra.test','giovanni.mele','ims-nagra.test','presence',1,1462195290</a>,'')
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...
</pre>
</blockquote>
Does oracle support replace sql statement?<br>
<br>
Cheers,<br>
Daniel<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference, Berlin, May 18-20, 2016 - <a class="moz-txt-link-freetext" href="http://www.kamailioworld.com">http://www.kamailioworld.com</a></pre>
</body>
</html>