Print Story ask husi: perl mysql stored procs?
My dear HuSi infidels, the time has come yet again for me to beg for your mercy.  Have any of you had to bear the burden the pleasure of hacking in Perl on MySQL's stored procedures?  Because I'm frigging stumped!


You take your very simple stored proc:

<pre>CREATE PROCEDURE test()
BEGIN
  SELECT 1;
END</pre>

It seems to me that using the Perl DBI you are utterly unable to call this stored procedure using either $dbh->do or $sth->prepare/execute.  I can call it from the cli just fine, as with python and php.  But it can't be totally impossible with Perl can it?  Something so basic to be impossible?

Yes, I know I could/should create an output variable and assign a value to it.  Except that is out of bounds for reasons I'm not going to go into.


Oh, and is anyone else glad that with the Democrats owning USian congress we've now got a new bogeyman to bitch at when the US gov't does stupid things?  Even I was getting sick of ragging on Republicans all the time!  Okay I wasn't, but still it's a nice change of pace.

Full discussion: http://www.hulver.com/scoop/story/2006/11/22/12758/182