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!

How to use "UPDATE SET ROW = <rowtype_record_variable> on tables with virtual columns without gettin

Berny2Mar 9 2017 — edited Mar 10 2017

I had the idea of using an updateable view <view_non_virtual> on this table which includes only all the non-virtual-columns of the table and use the <rowtype_record_variable > then based on this <view_non_virtual>. This way the UPDATE SET ROW = <rowtype_record_variable > seems to work fine without the usual: ORA-54017: UPDATE operation disallowed on virtual columns

What do you think about this approach?

Why is there no other, more implicitly working method for allowing SET ROW on tables with virtual columns?

This post has been answered by Paulzip on Mar 9 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 7 2017
Added on Mar 9 2017
14 comments
2,486 views