$sql = q{EXEC AUTH_USER @username = ?, @password = ?}; my ($user_id) = $dbh->selectrow_array($sql,{},$username,$password);