ORA-01732
data manipulation operation not legal on this view
Cause
An attempt was made to use an UPDATE, INSERT, or DELETE statement on a view that contains expressions or functions or was derived from more than one table. If a join operation was used to create the view or the view contains virtual columns derived from functions or expressions, then the view may only be queried.
Action
UPDATE, INSERT, or DELETE rows in the base tables instead and restrict the operations on the view to queries.
ORA-01732
data manipulation operation not legal on this view
Cause
An attempt was made to use an UPDATE, INSERT, or DELETE statement on a view that contains expressions or functions or was derived from more than one table. If a join operation was used to create the view or the view contains virtual columns derived from functions or expressions, then the view may only be queried.
Action
UPDATE, INSERT, or DELETE rows in the base tables instead and restrict the operations on the view to queries.
ORA-01732
data manipulation operation not legal on this view
Cause
An attempt was made to use an UPDATE, INSERT, or DELETE statement on a view that contains expressions or functions or was derived from more than one table. If a join operation was used to create the view or the view contains virtual columns derived from functions or expressions, then the view may only be queried.
Action
UPDATE, INSERT, or DELETE rows in the base tables instead and restrict the operations on the view to queries.