You need to use: sqlquery("connection_name","function Syntax ,"result variable")

Please see the example in the docs: http://kamailio.org/docs/modules/5.2.x/modules/sqlops.html#idm1027846556

Regards, Ovidiu Sas

On Mon, Feb 25, 2019 at 9:13 AM eyas barhouk eyas37@hotmail.com wrote:

Dear Henning thanks for kind reply,

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") kamailio gives execution Errors , so does kamailio sqlops module support Oracle function calling and if yes what is the correct syntax ??.

Best regards Eyas Barhok

---

From: Henning Westerholt hw@kamailio.org Sent: Monday, February 25, 2019 1:59 PM To: sr-users@lists.kamailio.org Cc: eyas barhouk Subject: Re: [SR-Users] Kamailio with oracle database

Am Montag, 25. Februar 2019, 12:01:57 CET schrieb eyas barhouk:

...

I'm trying to run kamailio with oracle 11g database and applying the needed querys by using Sqlops modules after applying the needed configuration i didn't find any Syntex to execute Oracle function from kamailio sqlops module . So is there any way to execute oracle function from kamailio ??

Hello Eyas,

have you tried to just call the function with sqlops? Do you get an error message?

I found some discussion from years ago related to postgres, people use it there.

https://lists.kamailio.org/pipermail/sr-users/2014-March/081856.html

Best regards,

Henning

Henning Westerholt - https://skalatan.de/blog/ Kamailio services - https://skalatan.de/services Kamailio security assessment - https://skalatan.de/de/assessment _______________________________________________ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users