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 :
This is what I get in the log:
How do I resolve this issue?
Apex 19.1
Oracle DB 19c
Robert G