in reply to Re: How to access MySQL stored procedures OUT parameter(s)
in thread How to access MySQL stored procedures OUT parameter(s)
Ah, yes, by "two step", I meant step#1:CALL DebugMe(@dmvar), step#2:SELECT(@dmvar). But I do appreciate the reminder of $dbh->do(). As you might be able to tell, I'm not actually a database guy. :-)
As far as the Multiple-data-sets, that was actually something I had run across in the documentation, and was probably going to experiment with... but $work got in the way of my coffee-break perl/mysql experimentation. :-)
In the end, I'll probably just switch to a stored function instead of stored procedure, because (so far), I only have one value I want returned. (I had been thinking about a second, but it hasn't materialized yet, and probably won't.)
Thanks for staying interested.