User enters a query in Code Editor and turns ON the Updateable query option via the Updateable icon of the Editor toolbar. When query is executed, Data Set remains as a Read-Only Data Set.
An example of the query:
select tablename.column1, tablename.column2 from tablename where tablename.column1=1
The table name is included with the column name in the Where clause of the query.
WORKAROUND:
Remove the table name from the column name in the Where clause of the query as such:
select tablename.column1, tablename.column2 from tablename where column1=1
STATUS:
Waiting for fix to be released in a future version of SQL Navigator for Oracle.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center