how can i update on block based on view

[mahmoudward]

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

[ABUSANAD]

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.

[ABUSANAD]

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

[informat]

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