Skip to Main Content

I am getting this error during creating an action through a form. How can I fix this?

Ashish RamdinAug 6 2021

Technical Info (only visible for developers)
is_internal_error: false
ora_sqlcode: -32795
ora_sqlerrm: ORA-32795: cannot insert into a generated always identity column ORA-06512: at "APEX_200200.WWV_FLOW_FORM_REGION", line 1256 ORA-06512: at "APEX_200200.WWV_FLOW_EXEC_LOCAL", line 2758 ORA-06512: at "APEX_200200.WWV_FLOW_DYNAMIC_EXEC", line 878 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_200200", line 676 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_200200", line 662 ORA-06512: at "APEX_200200.WWV_FLOW_DYNAMIC_EXEC", line 1769 ORA-06512: at "APEX_200200.WWV_FLOW_DYNAMIC_EXEC", line 1743 ORA-06512: at "APEX_200200.WWV_FLOW_DYNAMIC_EXEC", line 857 ORA-06512: at "APEX_200200.WWV_FLOW_DYNAMIC_EXEC", line 935 ORA-06512: at "APEX_200200.WWV_FLOW_EXEC_LOCAL", line 1939 ORA-06512: at "APEX_200200.WWV_FLOW_EXEC_LOCAL", line 2722 ORA-06512: at "APEX_200200.WWV_FLOW_EXEC", line 4466 ORA-06512: at "APEX_200200.WWV_FLOW_FORM_REGION", line 1135 ORA-06512: at "APEX_200200.WWV_FLOW_FORM_REGION", line 2255 ORA-06512: at "APEX_200200.WWV_FLOW_PROCESS_NATIVE", line 1211 ORA-06512: at "APEX_200200.WWV_FLOW_PLUGIN", line 2757
component.type: APEX_APPLICATION_PAGE_PROCESS
component.id: 15313963675928825
component.name: Process form Create a DSR
association_type: REGION
region_id: 15303175946928818
error_backtrace:
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_200200", line 662 ORA-06512: at "APEX_200200.WWV_FLOW_FORM_REGION", line 1256 ORA-06512: at "APEX_200200.WWV_FLOW_EXEC_LOCAL", line 2758 ORA-06512: at "APEX_200200.WWV_FLOW_DYNAMIC_EXEC", line 878 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_200200", line 676 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1658 ORA-06512: at "SYS.WWV_DBMS_SQL_APEX_200200", line 662 ORA-06512: at "APEX_200200.WWV_FLOW_DYNAMIC_EXEC", line 1769 ORA-06512: at "APEX_200200.WWV_FLOW_DYNAMIC_EXEC", line 1743 ORA-06512: at "APEX_200200.WWV_FLOW_DYNAMIC_EXEC", line 857 ORA-06512: at "APEX_200200.WWV_FLOW_DYNAMIC_EXEC", line 935 ORA-06512: at "APEX_200200.WWV_FLOW_EXEC_LOCAL", line 1939 ORA-06512: at "APEX_200200.WWV_FLOW_EXEC_LOCAL", line 2722 ORA-06512: at "APEX_200200.WWV_FLOW_EXEC", line 4466 ORA-06512: at "APEX_200200.WWV_FLOW_FORM_REGION", line 1135 ORA-06512: at "APEX_200200.WWV_FLOW_FORM_REGION", line 2255 ORA-06512: at "APEX_200200.WWV_FLOW_PROCESS_NATIVE", line 1211 ORA-06512: at "APEX_200200.WWV_FLOW_PLUGIN", line 2757 ORA-06512: at "APEX_200200.WWV_FLOW_PROCESS", line 203
error_statement:
insert into "U_ALERTS" ("ALERT_ID","SUBJECT","DATA_TYPE","DATA_STORAGE_LOCATION","KEYWORDS","GEO_LOCATION","COUNTRY_REGULATION","DATA_OWNER","OWNER_LOCATION","OWNER_LOCATION_REGULATION","STATUS")values(:APEX$VAL1,:APEX$VAL2,:APEX$VAL3,:APEX$VAL4,:APEX$VAL5,:APEX$VAL6,:APEX$VAL7,:APEX$VAL8,:APEX$VAL9,:APEX$VAL10,:APEX$VAL11)returning "ALERT_ID" into :APEX$RET1

Comments
Post Details
Added on Aug 6 2021
1 comment
214 views