Edit data in view with instead of trigger

[dheltzel]

I have a view with an instead of trigger. I can update the view with an update statement, but when I use the "edit data" option in PL/SQL Developer, it doesn't allow edits because it's using "select for update" to allow editing.

Any ideas about how to get around this? I want to allow certain "power users" to be able to edit certain data and control access with views. Simple views with triggers on the underlying table work fine, but a complex view with an instead of trigger.

 

[Marco Kalter]

I don't think there is a workaround for this. We'll see what we can do about this in an upcoming patch release.