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!

ORA-01402: view WITH CHECK OPTION where-clause violation

sect55Dec 14 2021

i am getting this error when inserting a row in APEX:
I am using an Form-Automatic Row Processing process. It is issued from a [Create] button.

parsing generated DML statement: insert into (select * from "VEHICLE_REGISTRATION"where(ID = :P5201_id
)
 with check option)
("ID","STATUS_ID","NUMBER_OF_ENGINES","RENEWAL_OR_NEW","PLATE_NUMBER","VIN_NUMBER","SERIAL_NUMBER","COMPANY","COMPANY_ASSET_NUMBER","STATE_REGISTRATION","STATE_LICENSE_PLATE_NO","FACILITY","EMERGENCY_RESPONSE","ALTERNATE","LESS_200_HOURS","SNOW_REMOVAL","PRE_EXISTING_LEASE","VEHICLE_MAKE","OTHER_MAKE","VEHICLE_TYPE","MODEL","MODEL_YEAR","BUILDING","CREATE_DATE","CREATED_BY","LAST_UPDATE_DATE","APPLICANT_NAME")values(:APEX$VAL1,:APEX$VAL2,:APEX$VAL3,:APEX$VAL4,:APEX$VAL5,:APEX$VAL6,:APEX$VAL7,:APEX$VAL8,:APEX$VAL9,:APEX$VAL10,:APEX$VAL11,:APEX$VAL12,:APEX$VAL13,:APEX$VAL14,:APEX$VAL15,:APEX$VAL16,:APEX$VAL17,:APEX$VAL18,:APEX$VAL19,:APEX$VAL20,:APEX$VAL21,:APEX$VAL22,:APEX$VAL23,:APEX$VAL24,:APEX$VAL25,:APEX$VAL26,:APEX$VAL27)returning "ID" into :APEX$RET1

The property of the process is :
image.pngThis is what I get in the log:
image.pngHow do I resolve this issue?
Apex 19.1
Oracle DB 19c

Robert G

This post has been answered by sect55 on Dec 14 2021
Jump to Answer
Comments
Post Details
Added on Dec 14 2021
1 comment
3,115 views