How to call stored procedure

CodeFoodPixels / node-promise-mysql

A wrapper for mysqljs/mysql that wraps function calls with Bluebird promises.

MIT License

338 stars 64 forks source link

How to call stored procedure #24

Closed dinuka-liyanage closed 7 years ago

dinuka-liyanage commented 7 years ago

I have tried with 'CALL test_proc('param1','param2')', but it's not working. There is no any query issues. If I tried this with mysql editor it's work fine. When I call this from javascript function it's not working. Is promise mysql not supported for stored procedure? I can't find anything regarding stored procedures in promise mysql documentation

CodeFoodPixels commented 7 years ago

Promise-mysql wraps mysqljs/mysql (currently we use v2.9.0), so that's where you'll need to look for documentation. If it doesn't seem to be working within promise-mysql, can you test with mysqljs/mysql and if it works using that please raise an issue here and I'll have a look.