"J A" <[EMAIL PROTECTED]> wrote on 03/01/2006 11:04:50 AM: > Does MySQL have the ability to send resultsets from stored procedures? > (similar to ref cursors in Oracle). > > _________________________________________________________________ > FREE pop-up blocking with the new MSN Toolbar – get it now! > http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ >
It depend on how you call the stored procedure if your client library can handle a resultset or not. If you treat it like a reqular query, most client libraries have little problem accepting the results of a SELECT statement called from within your SPROC. Shawn Green Database Administrator Unimin Corporation - Spruce Pine