User opens Schema Browser and opens a View then goes to the Data. The user is unable to insert or update records through the data grid and the icons for inserting a new record is grayed out.
However the user maybe able to insert a record into the View by using the Editor and running a "insert" statement.
The view is not updatable due to database restrictions. The view maybe read-only or not updatable. The view may have multiple joins and Toad cannot insert a record through normal means. The view may require Instead-Of-Triggers which Toad does not detect.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_8004.htm
Toad runs the following query to determine if a view is updatable:
select UPDATABLE, INSERTABLE, DELETABLE
from user_Updatable_columns
where table_name = :tn
and ((updatable='YES') or (insertable='YES') or (Deletable='YES'))
Where :tn is the name of the view. If the results are "No" then Toad will gray out the insert icons. Also, Toad updates tables and views using ROWID. When you make an edit in the grid, Toad will issue an update statement using ROWID in the ‘where’ clause. So, if you can’t select a ROWID in the view, Toad can’t update it.
WORKAROUND:
Insert into the view by using a SQL statement in the Editor window.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center