my $pr1 = qq{select customer_name from customer where id = ? };

##</code><code>##

$sth1->execute($emp_id);