my $sql = "call PROC()" ;
$sth = $dbh->prepare($sql);
$sth->execute();

# PROC is the name of the procedure.