I'm trying to update a record in block that I based on an updatable view.

I can update the record using SQL*Plus.

I get
FRM-40602: Cannot insert into or update data in a view

Is it not possible to update, insert, or delete records from the detail table of a view based on a master-detail relationship?

Thanks
mahmoud ward

You can't perform any DML in view in the following conditions:-

1- DML may affect the relation between the basic master table and child.
2- View been created by ORDER BY clause.
3- View been created using GROUP BY function.
4- View been create using WHERE clause which prevent you from performing DML statements.
5- View made of two or more tables(Complex View).

Some DML operations may apply for previous conditions but under restricted use.

الاخ السائل اعتذر لخطا غير مقصود وهو انك لاتستطيع استخدام ORDER BY مع ال VIEW ولكن مع ال Inline View.

أخي يمكنك استخدام Dml triggers لكي تستطيع إنجاز Insert داخل view