Skip to Main Content

APEX

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!

insert through instead of triggers on view

hendergOct 11 2004 — edited Oct 16 2004
I have been trying to insert records through instead of triggers on a view. Keep hitting ORA-22816: unsupported feature with RETURNING clause.

Applied patch 1 to HTMLDB to fix it and it does not.

All tables are local (none through db link).

Can this be done or do I have to kludge the create button to call a stored proc?

Other forum posts indicated to including the returning clause on the insert would address the issue....it didn't either.

Sorry ....am a newbie to the forum.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 13 2004
Added on Oct 11 2004
3 comments
583 views