You can executed any SQL statements you want through 'sqlops', including invocation of stored procedures.
Our Kamailio-based Class 4 routing/trunking product is built almost entirely on Postgres stored procedures. We have dozens of them.
As to whether they are "really needed", I don't know how to answer that. :-) In our case, we decided they were really needed because they offer the opportunity to execute complex business logic beyond what Kamailio's relatively primitive route scripting language can offer, while eliminating unnecessary back-and-forth data interchange between Kamailio and the database. Stored procedures and triggers also execute in a transactional manner, which is additionally beneficial.
Shankar shankar.rk@plintron.com wrote:
-- Sent from my mobile, and thus lacking in the refinement one might expect from a fully fledged keyboard.
Alex Balashov - Principal Evariste Systems LLC 235 E Ponce de Leon Ave Suite 106 Decatur, GA 30030 United States Tel: +1-678-954-0671 Web: http://www.evaristesys.com/, http://www.alexbalashov.com