Thanks for the replay but when i try assert( con:execute("call csp_test();", function(qrow) for key, val in pairs(qrow) do myrow[key] = val found = found + 1 end end ) ) *i got error:* LuaSQL: Error executing query. MySQL: PROCEDURE test.csp_test can't return a result set in the given context and when i try assert( con:query("call csp_test();", function(qrow) for key, val in pairs(qrow) do myrow[key] = val found = found + 1 end end ) ) *i got Error:* attempt to call method 'query' (a nil value) any further help. ----- Regards Shahzad Bhatti +92-300-433-4033 +92-321-401-8917 -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/Calling-stored-procedure-in-fr... Sent from the freeswitch-users mailing list archive at Nabble.com.