Forum Stats

  • 3,759,229 Users
  • 2,251,515 Discussions
  • 7,870,546 Comments

Discussions

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

Ashish Ramdin
Ashish Ramdin Member Posts: 16 Green Ribbon

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


Tagged:

Answers