Originally posted by jef72
You can create a Database link on one database. Like that, you'll need to connect to only one database and can retrieve data from the other database at the same time.
I hope it'll help you.
You can make another connection using EXEC_SQL.
That is make the new connection, perform yor transactions
and exit out. When you exit, your first connection is still valid.
If you can plan properly and use it with some PL/SQL tables to
hold data , it gets you very close to having two connections open