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 <eya...@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 <h...@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



-- 
VoIP Embedded, Inc.
http://www.voipembedded.com

_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users

Reply via email to