Return result set from stored procedure / Pear::DB?

[Michael Flanagan]

I'm using Pear's DB package, and now want to introduce stored procedures. I have a stored procedure that simply does a SELECT, selecting several rows. I call the stored procedure in a call to the DB::query call, and get an error, telling me:

[nativecode=1312 ** PROCEDURE neighborhoodserver.proc_Get_available_coupons can't return a result set in the given context]'

1. I interpret that to mean that someone (PEAR?) cannot handle a result set from a stored procedure. Is that what the error is telling me?

2. Can I access a result set (multiple rows and columns) directly using PEAR::DB?

3. Can I access a result set (multiple rows and columns) directly using something other than PEAR::DB? If so, what do you recommend?

Thanks in advance.