On May 26, 8:27 am, GregD <[email protected]> wrote: > Okay, > > This made me look at it closer. I was passing in a hash instead of an > array for the args. Now, it seems hung. I'll let you know it I get > success or not once I figure out why it did not return. > > Do I need to set :sproc => true if this is a procedure vs a function? > > Thanks, > > GregD
You don't need to set :sproc => true. Actually, you are using the wrong interface. While call_sproc is a Database method, you should be using the call_sproc Dataset method: DB.dataset.call_sproc(:select, :name, arg1, arg2, arg3, ...) DB.dataset.call_sproc(:insert, :other_name, arg1, arg2, arg3, ...) The reason it is a dataset method instead of a database method is that you can have stored procedures operate like a dataset, in that they can do inserts, updates, deletes, and selects. Making it a dataset method allows you to set up a row proc so that you can have stored procedure calls that automatically yield model objects. 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.
