my $id = 10;
$sth = $dbh->prepare('SELECT PRODUCT_ID FROM schema.products@dblink_to_testdb where (product_id=?)');
$sth->execute($id);