Re: Stored procedure support?

On 4/24/06, Jake Peavy <[email protected]> wrote:
>
> On 4/24/06, Richard N. Fogle <[email protected]> wrote:
> >
> > Is there anyone on this list?
> >
> > Rich
> >
> > ----- Original Message -----
> > From: "Richard N. Fogle" <[email protected]>
> > To: < [email protected]>
> > Sent: Monday, April 17, 2006 10:42 PM
> > Subject: Stored procedure support?
> >
> >
> > I've been developing perl SOAP services in conjunction with our Java
> > team's
> > front-end development, and we're using MySQL5; the JDBC driver as full
> > support for stored procedures but I am at a loss with DBD::mysql.  I've
> > found mention of a patch, mention that it is already supported, etc, but
> > I
> > honestly can't find a simple example of how to use them.  Do we just use
> >
> > prepared statements as per the norm, or am I totally off and stored
> > procedures are not supported yet?  Thank you in advance and apologies if
> > this question is redundant.
> >
> > Rich
> >
>
> Did you try it?  If so, what happened?
>
> I haven't used SP's yet either, but I assume, if the user you're
> connecting to the server as has the appropriate permissions, you will just
> execute the SP with $dbh->do( 'stored_procedure' ).  But, in order to test
> my theory, I'd write a basic SP (like one that inserts NOW() into a test
> table) and then write a quick 10-line Perl script to test it.  Either that
> or you could harass the general public until they write a nice tidy HowTo
> response to your question...
>
> Up to you...
>
> --
> -jp
>
>
> When Chuck Norris exercises, the machine gets stronger.
>


Forgot the goddamned mailing list....  could _someone_ at MySQL please
change that?  God!

-jp