my $sth = $dbh->prepare("SELECT name from employee where empno= ?"); 
   
  $sth->execute($empno->{empno}); 
  my $emp= $sth->fetchrow;

$sth->execute(); 
my $name = $sth->fetchrow;