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