This content has been marked as final. Show 4 replies
The easiest way I can think to do this would be to use database links in the schema for the APEX workspace. Remember that each APEX workspace created has it's own schema at the Oracle level.
Database Links will rely on and use the information in the TNSNAMES.ORA file on the database server.
I hope that leads you in the right direction.
R. Otto R. Wessels
the question may be simple, but it still doesn't make sense. As Hari alluded to, coming to an understanding of the Apex architecture should answer your questions.
This is because TNS connections allow connections to a database by a client. In the case of Apex, it is a 3 tier architecture meaning the connection to the database is handled by an application server, and not the user client, which is a browser. This means that any TNS configuration happens between the application server, typically Oracle's HTTP server or the Apex Listener, and the database. In the case of the embedded PL/SQL gateway (EPG) no TNS configuration is necessary as the EPG is embedded in the database.
I hope this helps you understand why your question didn't make sense.