Apex 4.0 showing some real problems when working with tables over a database link. Apex is just unable to get the table columns in the wizards and much more because it is adding the wrong table owner via a PL/SQL function. We tried using synonyms but this also won’t work. The solution is easy but you have to put a little extra afford into it. Just create a view of the remote table by using:
CREATE VIEW myremotetable AS SELECT * FROM myremotetable@remotedatabase.world.com
Don’t forget to refresh the views if you update the remote table!
