Hello community
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 ??
Best regards
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
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
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