반품
-
제목
Is there an option to deactivate the RETURNING clause, which is automatically sent from SQL Nav? -
설명
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?
-
원인
An issue with View Editor is confirmed in 6.7 and 7.x versions. The issue stops a user from updating a Table via editing data in a View. There is no option to remove the returning clause or workaround at the moment. -
해결 방안
WORKAROUND:
None.
STATUS:
Waiting for fix in a future release of SQL Navigator for Oracle -
결함 ID
SQLNAV-1773