Greetings,
I've developed an APEX app on Oracle OCI - always free cloud account. Now, I need to host my app in another hosting company. But I need the app to access data(query and dml operations) on my autonomous database ADB of my always Free OCI account.
I need to do that without changing anything in the code.
For example, there could be a region that select data from some_table. I need it to get the data from that same table in my OCI account.
I know that I can create a datbase link, but I'll then need to add @dblink at the end of every statement that has to do with tables, views or else. So, what I need is an option in APEX that tells the app that it's parsing schema resides on a remote database - which is mine on OCI account.
Is there an option like that in APEX?