<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="color: rgb(0, 0, 0); font-family: Calibri, Helvetica, sans-serif; font-size: 12pt;">Dear </span><span style="color: rgb(51, 51, 51); font-family: "Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; font-size: 14.6667px;">Henning
<span id="SmartSuggestionsKeyword473879" title="Search for suggestions" class="_1okoJpT9HZqFCFE-Qxz_m9">
thanks</span> for kind reply, </span><br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="color: rgb(51, 51, 51); font-family: "Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; font-size: 14.6667px; background-color: rgb(255, 255, 255); display: inline !important"><br>
</span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<span style="color: rgb(51, 51, 51); font-family: "Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif; font-size: 14.6667px; background-color: rgb(255, 255, 255); display: inline !important">yes
i already tried to use SQLOPS module and the connection was up, but when i'm trying to to call oracle function by using sqlquery(connection_name,"function Syntax ,"result variable") </span></div>
<div style=""><span style="font-size: 14.6667px;">kamailio gives execution Errors , so does kamailio sqlops module support Oracle function calling and if yes what is the correct syntax ??.</span></div>
<div style=""><span style="font-size: 14.6667px;"><br>
</span></div>
<div style=""><span style="font-size: 14.6667px;">Best regards </span></div>
<div style=""><span style="font-size: 14.6667px;">Eyas Barhok </span></div>
<div style=""><span style="font-size: 14.6667px;"><br>
</span></div>
<div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> Henning Westerholt <hw@kamailio.org><br>
<b>Sent:</b> Monday, February 25, 2019 1:59 PM<br>
<b>To:</b> sr-users@lists.kamailio.org<br>
<b>Cc:</b> eyas barhouk<br>
<b>Subject:</b> Re: [SR-Users] Kamailio with oracle database</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt">
<div class="PlainText">Am Montag, 25. Februar 2019, 12:01:57 CET schrieb eyas barhouk:<br>
> I'm trying to run kamailio with oracle 11g database and applying the needed<br>
> querys by using Sqlops modules after applying the needed configuration i<br>
> didn't find any Syntex to execute Oracle function from kamailio sqlops<br>
> module . So is there any way to execute oracle function from kamailio ??<br>
<br>
Hello Eyas,<br>
<br>
have you tried to just call the function with sqlops? Do you get an error <br>
message?<br>
<br>
I found some discussion from years ago related to postgres, people use it <br>
there.<br>
<br>
<a href="https://lists.kamailio.org/pipermail/sr-users/2014-March/081856.html">https://lists.kamailio.org/pipermail/sr-users/2014-March/081856.html</a><br>
<br>
Best regards,<br>
<br>
Henning<br>
-- <br>
Henning Westerholt - <a href="https://skalatan.de/blog/">https://skalatan.de/blog/</a><br>
Kamailio services - <a href="https://skalatan.de/services">https://skalatan.de/services</a><br>
Kamailio security assessment - <a href="https://skalatan.de/de/assessment">https://skalatan.de/de/assessment</a><br>
</div>
</span></font></div>
</div>
</body>
</html>