lauravachon
6 years agoContributor
oracle jdbc query across a database link
I am having a problem with my sql query that queries data in two different databases via a database link.
e.g.
get fdb.this, fdb.that from firstdb fdb
join view.sceonddb@dblink sdb on
fdb.this = sdb.this and fdb.that = scb.that
where fdb.this is not null and fdb.that is not null
returns results in my db tool and also in my java code, but returns empty in soapui pro.
Any ideas?