Hi all,
I have two databases, let say A_local and B_remote.
On A_local there is
- data schema A and parsing schema A_APEX
- a database link pointing to a schema on database B_remote.
- synonyms and views to have access to those remote objects on B_remote.
On my APEX page there is 1 master table and 3 detail tables all using interactive grid. Because it is not possible to do an insert and fetch the generated ID values using returning clause for remote tables, I create a manual pl/sql code to process each row of data manipulated in IG for DML.
And now
- Insert on all tables worked
- update and delete on detail tables worked as well.
But if I try to update/ delete records on my master table I got following error:
ORA-02015: cannot select FOR UPDATE from remote table
Had anyone know what the reason could be?
Thanks and best,
Jennifer