SQL Navigator for Oracle (version 5.5.4) made an update by sending:
update table set column=’xyz’ where rowid=’AAA…..’
In version 6.7.0 the statement is:
update table set column=’xyz’ where rowid=’AAA…..’
returning rowid into NULL
When you have to update a view with INSTEAD OF trigger, an error occurs: 'ORA-22816: unsupported feature with RETURNING clause.'
Is it possible to deactivate the returning clause, which is automatically sent from the grid (SQL-Nav) to the Oracle database?
