|
Oracle Error Code |
|
|
ora-01732 |
|
Description |
|
|
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. |
|
How to Solve |
|
|
|
UPDATE, INSERT, or DELETE rows in the base tables instead and restrict the operations on the view to queries.
|
|
|
| Posts About Oracle Database Error ORA-01735 | | Michael: | Views cannot always be updated, and it is understandable
because a view is basically a select statement not a storage object.
|
|
|
Do you have question or do you know about solution ?
Share with us. (No registration required)
|
|
Similar Errors |
|
|
|