MySQL Forums
Forum List  »  Perl

Problem in executing stored procedures inside foreach loop - i.e. multiple execution
Posted by: vinod philip
Date: May 21, 2008 10:00AM

I am trying to run a stored procedure in foreach loop of perl script ,which accepts 2 dynamic parameters. First time it successfully execute, but it does't execute the second time.
e.g
foreach $userid(@selecteduserid)
{
$sth=$dbh->prepare("call testprocedure($userid,$category);");
$sth->execute();
}


Can anyone help me please. Many thanks

Options: ReplyQuote


Subject
Written By
Posted
Problem in executing stored procedures inside foreach loop - i.e. multiple execution
May 21, 2008 10:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.