[prev in list] [next in list] [prev in thread] [next in thread]
List: apache-modperl
Subject: RE: Can't use mysql stored procedures under mod_perl (although they work directly from Perl)
From: "Jonathan H Lundquist" <jhl () bonipak ! com>
Date: 2006-07-31 17:15:42
Message-ID: 00c201c6b4c4$f45aaa10$0a01010a () jhl
[Download RAW message or body]
Thanks for your reply; it is the only one so far. I will give 3.0006_1 a
try, but I'm not hopeful, as I think we probably are dealing with a mod_perl
bug. I am using 3.0006, but as I stated it has been patched for multiple
result set (procedure) support, and it is calling procedures successfully in
both straight Perl command line use and via fcgid.
-----Original Message-----
From: Frank Maas [mailto:frank.maas@cheiron-it.nl]
Sent: Monday, July 31, 2006 5:16 AM
To: jhl@bonipak.com; modperl@perl.apache.org
Subject: RE: Can't use mysql stored procedures under mod_perl (although they
work directly from Perl)
> -------------8<---------- Start Bug Report ------------8<----------
> 1. Problem Description:
>
> I'm trying to use stored procedures in a mysql database from within a perl
> script.
> A simple test script runs fine from a command-line perl interpreter, and
> runs fine
> when invoked via CGI.
>
> The same script always fails when run under mod_perl, receiving:
> ERROR: 1312 'PROCEDURE ceres_bt.create_inventory_lot can't return a result
> set in the given context'
Has someone replied to this? If so, sorry for this double post. If not: this
is not a mod_perl bug. It is caused by an imcompatibility between DBD::MySQL
(production branch) and new features in MySQL, see
http://forums.mysql.com/read.php?51,63934,63934#msg-63934. As you can see
from http://www.nntp.perl.org/group/perl.dbi.announce/298, support for
resultsets from procedures is available through the development version
(3.0006_1).
Regards,
Frank
!DSPAM:44cdf48833612134717754!
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic