On Sep 2, 5:09 am, Watchdog6241 <[email protected]> wrote: > Hi > Can you help on a hello world sequel, I'm ok calling a stored > procedure and passing in a parameter(s), but how do I get return > parameters e.g from the below example > > (MYSQL 5.1x) > > CREATE DEFINER = 'root'@'localhost' PROCEDURE `usp_get`( > IN chair_in INTEGER, > OUT testa INTEGER(11) > ) > NOT DETERMINISTIC > CONTAINS SQL > SQL SECURITY DEFINER > COMMENT '' > begin > set testa = 12345; > end > > Thanks for help :)
Unfortunately, Sequel doesn't have any support for IN/OUT parameters in stored procedures. With Sequel, if you want to get information out of a stored procedure, you have to have the stored procedure return rows. Jeremy --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en -~----------~----~----~----~------~----~------~--~---
