Stored procedure support?

------=_NextPart_000_01F8_01C66270.277F2120
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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

---------------------------
Assiduus usus uni rei deditus et ingenium et artem saepe vincit.
rich@neosaint.org
------=_NextPart_000_01F8_01C66270.277F2120--

Re: Stored procedure support?

Is there anyone on this list?

Rich

----- Original Message -----
From: "Richard N. Fogle"
To:
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

---------------------------
Assiduus usus uni rei deditus et ingenium et artem saepe vincit.
rich@neosaint.org


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Stored procedure support?

Richard N. Fogle wrote:
> Is there anyone on this list?

I'm here. :-)

I just didn't have a very good answer to your question, I've used
triggers but not prepared statements (yet). The triggers are a part of
Schema::RDBMS::AUS... they're not quite the same as prepared statements but
they're close... have a look and you'll see what sort of aggrivation I've
gone through trying to do stuff as simple as raising exceptions...

http://search.cpan.org/src/CRAKRJACK/Schema-RDBMS-AUS-0.03/s chema/mysql/0.01/

Cheers,
Tyler


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Stored procedure support?

Tyler,

Thanks for the reply! Didn't want to ask a question that was hammered to
death or an RTFM, but I honestly can't find the answer anywhere. I did post
the same question on the MySQL developer's forum, odd that I received an
answer there but not here, thus me wondering if I was on the right list or
not! Here is the posting:

http://forums.mysql.com/read.php?51,85094,85276#msg-85276

Ouch, is DBD::mysql dying or something? I know well of the LAMP hype, but I
kind of figured Perl was in there too. No release in about a year tho'. Is
there anything we can do to help?

Rich

----- Original Message -----
From: "Tyler MacDonald"
To: "Richard N. Fogle"
Cc:
Sent: Monday, April 24, 2006 5:10 PM
Subject: Re: Stored procedure support?


> Richard N. Fogle wrote:
>> Is there anyone on this list?
>
> I'm here. :-)
>
> I just didn't have a very good answer to your question, I've used
> triggers but not prepared statements (yet). The triggers are a part of
> Schema::RDBMS::AUS... they're not quite the same as prepared statements
> but
> they're close... have a look and you'll see what sort of aggrivation I've
> gone through trying to do stuff as simple as raising exceptions...
>
> http://search.cpan.org/src/CRAKRJACK/Schema-RDBMS-AUS-0.03/s chema/mysql/0.01/
>
> Cheers,
> Tyler
>
>


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Stored procedure support?

------=_Part_13920_29285551.1145922854304
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On 4/24/06, Jake Peavy wrote:
>
> On 4/24/06, Richard N. Fogle wrote:
> >
> > Is there anyone on this list?
> >
> > Rich
> >
> > ----- Original Message -----
> > From: "Richard N. Fogle"
> > To: < perl@lists.mysql.com>
> > 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, bu=
t
> > I
> > honestly can't find a simple example of how to use them. Do we just us=
e
> >
> > prepared statements as per the norm, or am I totally off and stored
> > procedures are not supported yet? Thank you in advance and apologies i=
f
> > 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 jus=
t
> execute the SP with $dbh->do( 'stored_procedure' ). But, in order to tes=
t
> 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 tha=
t
> 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

------=_Part_13920_29285551.1145922854304--

Re: Stored procedure support?

------=_NextPart_000_0041_01C667D4.15C7EF70
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Yes, we're re-writing our queries into SPs like the norm for Oracle =
development.. I wrote several, the cursors are a bit limited but it is =
'good enough' for most of what we have. I called an SP using $dbh->do() =
and preparing a statement, I received what is talked about in this =
thread:

http://forums.mysql.com/read.php?51,63934,63960#msg-63960

Since that was almost a year ago I figured that the changes/fixes were =
out there and I was simply missing it. I'd be ok writing a HOWTO, but =
the functionality isn't there.

Rich

----- Original Message -----=20
From: Jake Peavy=20

Did you try it? If so, what happened?=20

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... =20

Up to you...

--=20
-jp


When Chuck Norris exercises, the machine gets stronger.
------=_NextPart_000_0041_01C667D4.15C7EF70--