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
