1 : Yes, link with a @
2 : I didn’t turn of the “Upd opt”, but made a rollback, closed the editor.
SELECT succ, application, localite FROM s_suc_doua@pseabird_plda WHERE succ = 372
SUCC APPLICATION LOCALITE ROWID*
372 CS1 WELKENRAEDT AAAr4AAAmAAAMNmAAM
372 CS2 WELKENRAEDT AAAr4AAAmAAAMNmAAN
372 CSW WELKENRAEDT AAAr4AAAmAAAMNcAAR
372 EME WELKENRAEDT AAAr4AAAmAAAMNgAAF
372 EMI WELKENRAEDT AAAr4AAAmAAAMNgAAB
I edit the first one, and make COMMIT; -> 09:11:56 ORA-22816: unsupported feature with RETURNING clause
The days before (beta 3860 ?) I do a rollback, everything seems to be OK in the editor. Impossible to edit the record directly in the destination database, it’s still locked. I closed the editor and record still locked, I had to close completely SQL Navigator to unlock the record.
Today (beta 3883 just installed) : I still get the ORA-22816 error, but when I do the ROLLBACK, record is released.