Update rows in remote table thru synonym
Hello all,
I am new to Apex and I have searched this forum about this issue, but couldn't find any.
Here is what I am trying to do.
I have DB1, where the Apex is installed. And, I would like to access/update data in db2 tables. These are the steps I followed
1. Created a dblink in DB1 to DB2.
2. Created synonym in DB! for TableA of remote table i.e. DB2. create synonym tablea_syn for tablea@dblink1;
3. Now, thru object browser of Apex, I would be able to update/insert/delete records in tableA@dblink. So, I selected synonyms in the object browser, but not able to see any rows that are present in tableA@dblink1. I am bale to see the rows using Toad.
Is it possible to update/delete or insert new rows into remote tables using synonyms thru Apex?
Please help me out with this issue.
Thanks in advance.