Gecko [ nbspublicschool.com ]

Name	Size	Permission
bug14979.pl	789 B	-rw-r--r--
bug21028.pl	2.19 KB	-rw-r--r--
bug30033.pl	868 B	-rw-r--r--
bug30033pg.pl	456 B	-rw-r--r--
decimal_test.pl	839 B	-rw-r--r--
issue21946.pl	848 B	-rw-r--r--
prepare_memory_usage.pl	450 B	-rw-r--r--
proc_example1.pl	1.03 KB	-rw-r--r--
proc_example2.pl	1.38 KB	-rw-r--r--
proc_example2a.pl	1.29 KB	-rw-r--r--
proc_example2b.pl	1.27 KB	-rw-r--r--
proc_example3.pl	901 B	-rw-r--r--
proc_example4.pl	1.36 KB	-rw-r--r--

Code Editor : proc_example4.pl

#!/usr/bin/perl

use DBI;
use strict;
use Data::Dumper;
use warnings;
my $connect_string = 'DBI:mysql:database=test';
my $username = 'root';
my $password = '';
my $attributes = {};
my $dbh = DBI->connect($connect_string, $username,
$password, $attributes) || die $DBI::errstr;

# Execute this AT LEAST once so the stored procedure someproc() exists
# at least
$dbh->do("drop procedure if exists someproc") or print $DBI::errstr;

# Comment this out to reproduce the bug
$dbh->do("create procedure someproc() deterministic begin ".
 "declare a,b,c,d int; set a=1; set b=2; set c=3; set d=4; ".
 "select a, b, c, d; select d, c, b, a; select b, a, c, d; ".
 "select c, b, d, a; end") or print $DBI::errstr;
my $sth=$dbh->prepare('call someproc()') || die $DBI::errstr;
$sth->execute || die $DBI::errstr;
my @row= $sth->fetchrow_array();
print Dumper \@row;
my $more_results = $sth->more_results();
print $more_results . "\n";
@row= $sth->fetchrow_array();
print Dumper \@row;
$more_results = $sth->more_results();
print $more_results . "\n";
@row= $sth->fetchrow_array();
print Dumper \@row;
$more_results = $sth->more_results();
print $more_results . "\n";
@row= $sth->fetchrow_array();
print Dumper \@row;
$more_results = $sth->more_results();
print $more_results . "\n";
@row= $sth->fetchrow_array();
print Dumper \@row;
$more_results = $sth->more_results();
print $more_results . "\n";

${this.title}

Code Editor : proc_example4.pl