 | | | Subject: Re: Problem when calling stored procedure | Subject: Re: Problem when calling stored procedure 2007-11-09 - By Wagner, Chris (GEAE, CBTS)
Back
Hi. In the second one ur passing an anonymous hash to the prepare()
function. It needs to be a scalar like in ur first example. So just
get rid of the {}'s and it should work assuming $procedure eq
$linproc[0].
Pierre Hainard wrote:
> # Calling the procedure
> $para1 = 10;$para2 = 12;
> my $procedure = "CALL p1($para1,$para2)";
>
> #this one does work
> my $sth = $dbh->prepare($procedure);
> #this one does not work why ??
> #my $sth = $dbh->prepare({$linproc[0]});
> $sth->execute();
--
Chris Wagner
CBTS
GE Aircraft Engines
Chris.Wagner@(protected)
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=mysql@(protected)
|
|
|