APEX

Hello everybody,

I get the following when I try to open the modal page. Can anyone help me to fix it? Thanks!!

ORA-01722: invalid number

• is_internal_error: false
• ora_sqlcode: -1722
• ora_sqlerrm: ORA-01722: invalid number
• component.type: APEX_APPLICATION_PAGE_PROCESS
• component.id: 621721365609952
• component.name: Fetch Row from ALL_THREE
• error_backtrace:

  ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SYS_SQL", line 2107 ORA-06512: at "SYS.WWV_DBMS_SQL", line 1033 ORA-06512: at "SYS.WWV_DBMS_SQL", line 1047 ORA-06512: at "APEX_050000.WWV_FLOW_DYNAMIC_EXEC", line 895 ORA-06512: at "APEX_050000.WWV_FLOW_DML", line 764 ORA-06512: at "APEX_050000.WWV_FLOW_PROCESS_NATIVE", line 526 ORA-06512: at "APEX_050000.WWV_FLOW_PROCESS_NATIVE", line 1106 ORA-06512: at "APEX_050000.WWV_FLOW_PLUGIN", line 2014 ORA-06512: at "APEX_050000.WWV_FLOW_PROCESS", line 188 

• error_statement:

  begin begin  select "ID","PRE_ID","SYSTEM","ML_VERSION",to_char("STATUS_DATE", :p$_format_mask1),"LOCATION","DATA_SYSTEM","PHYSICALHOST","PHYSVIRTUAL","DOMAINNAME","IPADDRESS","PURPOSE","DESCRIPTION","ATO","ATOAPP","OWNER","CMSOURCE","OS","HWMODEL","HARDWARECPU","NETWORK","CPUS","MEMORY","DISK","STATUS","NOTES",to_char("CREATE_DATE", :p$_format_mask2),to_char("DESTROY_DATE", :p$_format_mask3),"SPLUNK","AUTO_DISCOVERY","BARCODE","IS_SSH","MONITORED",to_char("SCAN_DATE", :p$_format_mask4),"CURRENT_BL","PT_IS_PUPPET","PT_PUPPETVAR_CLUSTER","PT_PUPPETVAR_ROLE","PT_PUPPETCLASS","PT_ENVIRONMENT","PT_PUPPETCLASSES","PT_PUPPETVARIABLES","ROOM","RACKNUM","STARTPOSITION","ENDPOSITION" into wwv_flow.g_column_values(1),wwv_flow.g_column_values(2),wwv_flow.g_column_values(3),wwv_flow.g_column_values(4),wwv_flow.g_column_values(5),wwv_flow.g_column_values(6),wwv_flow.g_column_values(7),wwv_flow.g_column_values(8),wwv_flow.g_column_values(9),wwv_flow.g_column_values(10),wwv_flow.g_column_values(11),wwv_flow.g_column_values(12),wwv_flow.g_column_values(13),wwv_flow.g_column_values(14),wwv_flow.g_column_values(15),wwv_flow.g_column_values(16),wwv_flow.g_column_values(17),wwv_flow.g_column_values(18),wwv_flow.g_column_values(19),wwv_flow.g_column_values(20),wwv_flow.g_column_values(21),wwv_flow.g_column_values(22),wwv_flow.g_column_values(23),wwv_flow.g_column_values(24),wwv_flow.g_column_values(25),wwv_flow.g_column_values(26),wwv_flow.g_column_values(27),wwv_flow.g_column_values(28),wwv_flow.g_column_values(29),wwv_flow.g_column_values(30),wwv_flow.g_column_values(31),wwv_flow.g_column_values(32),wwv_flow.g_column_values(33),wwv_flow.g_column_values(34),wwv_flow.g_column_values(35),wwv_flow.g_column_values(36),wwv_flow.g_column_values(37),wwv_flow.g_column_values(38),wwv_flow.g_column_values(39),wwv_flow.g_column_values(40),wwv_flow.g_column_values(41),wwv_flow.g_column_values(42),wwv_flow.g_column_values(43),wwv_flow.g_column_values(44),wwv_flow.g_column_values(45),wwv_flow.g_column_values(46) from "TEST"."ALL_THREE" where "ID" = :p_rowid; end; end;