Skip to Main Content

SQL & PL/SQL

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!

ORA-22816: unsupported feature with RETURNING clause

683678Feb 16 2009 — edited Feb 16 2009
I am trying to Insert a row into a view the view has 3 Instead of triggers. (insert, update, delete)
I have looked up this error and have seen that you cannot use a RETURNING clause on view with INSTEAD OF triggers
because it is not supported.

My issue is, I cannot find any code around this views where a RETURNING clause is being used.
Does anyone have any idea what else this could be??
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 16 2009
Added on Feb 16 2009
10 comments
3,468 views