my $condition = $oracle_connector->opts->condition;
my @bind_values = ();
my $where = "";
if ( $condition =~ /\S/ ) {
    push @bind_values, $condition;
    $where = " WHERE status = ?";
}

my $sth = $db->prepare("SELECT COUNT(*) from CONNECTOR.$table$where");

$sth->execute( @bind_values );  # works as intended if @bind_values is empty