Re: Problem when calling stored procedure

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
[email protected]

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]