Skip to Main Content
Forums

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-54017: UPDATE operation disallowed on virtual columns

959406Oct 19 2016 — edited Oct 19 2016

Hi

while update the below query that show ORA-54017: UPDATE operation disallowed on virtual columns

how to update the below query?

query :

UPDATE jur_verify_out out

SET jur_sec = jur_sec||',JUR_US',

re_us='Y',

jur_cum = jur_com||',JUR_US'

where (out.tid,out.int_id) in (select s.tid,s.int_id from jur_verify_input in

where in.tid=out.tid and in.int_id=out.int_id);

Thanks

Message was edited by: 959406
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 16 2016
Added on Oct 19 2016
6 comments
525 views