Not knowing how PL/SQL Developer works in this area I tried to write an SQL*Plus "equivalent" as follows - which works fine.
DECLARE
CURSOR c1 IS
SELECT title
FROM schema.table@db_link t
FOR UPDATE OF title;
v1 c1%ROWTYPE;
BEGIN
OPEN c1;
FETCH c1 INTO v1...
When I try to execute the following statement:
SELECT t.* from schema.table@db_link t FOR UPDATE
The statement executes fine (and returns rows) but as soon as I click the "Edit Data" padlock icon I get the error message:
"These query results are not updateable. Include the ROWID to get...