$sth = $dbh->prepare('SELECT PRODUCT_ID FROM schema.products@dblink_to_testdb where (product_id=?)') or die $dbh->errstr; $sth->execute($partnr) or die $dbh->errstr;