Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FRM-40602 - Cannot insert into a view. View already has INSTEAD of Trigger

31883Mar 25 2003 — edited Oct 9 2006

Hi,

I have view that is a union of 2 select statements. I have a INSTEAD of trigger that performs insert, update, delete on the view. Using sqlplus, I can perform dml on the view without problems. Now if I tried to based a block on the view, it keeps erroring: FRM-40602 Cannot insert into or update data in a view.

I have other blocks that based on views and work. Only those views do not have unions in them.

Any workaround?

Thanks,
Ernest

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 6 2006

Added on Mar 25 2003

#forms, #moved-from-devops

5 comments

13,804 views