Hello community
I am testing APEX. I have created an application with some simple forms with no problem.
But with a master-detail form, when I want to add rows to the detail tables, if there are no rows in the detail block, I get an error:
ORA-01403: no data found
Contact your application administrator. Details about this incident are available via debug id "1882".
Technical Info (only available for developers)
is_internal_error: false
ora_sqlcode: 100
ora_sqlerrm: ORA-01403: no data found
ORA-06512: at "APEX_230100.WWV_FLOW_FORM_REGION", line 2306
ORA-06512: at "APEX_230100.WWV_FLOW_FORM_REGION", line 2267
ORA-06512: at "APEX_230100.WWV_FLOW_FORM_REGION", line 2348
ORA-06512: at "APEX_230100.WWV_FLOW_PROCESS_NATIVE", line 1379
ORA-06512: at "APEX_230100.WWV_FLOW_PLUGIN", line 3448
component.type: APEX_APPLICATION_PAGE_PROCESS
component.id: 9854072037356268
component.name: Initialize form Paises Divisione
association_type: REGION
region_id: 9847693345356252
error_backtrace:
ORA-06512: at "APEX_230100.WWV_FLOW_FORM_REGION", line 2306
ORA-06512: at "APEX_230100.WWV_FLOW_FORM_REGION", line 2267
ORA-06512: at "APEX_230100.WWV_FLOW_FORM_REGION", line 2348
ORA-06512: at "APEX_230100.WWV_FLOW_PROCESS_NATIVE", line 1379
ORA-06512: at "APEX_230100.WWV_FLOW_PLUGIN", line 3448
ORA-06512: at "APEX_230100.WWV_FLOW_PROCESS", line 191
On the other hand, if the detail block contains more than one row, the error is:
ORA-01422: exact fetch returns more than requested number of rows
Contact your application administrator. Details about this incident are available via debug id "1883".
Technical Info (only available for developers)
is_internal_error: false
ora_sqlcode: -1422
ora_sqlerrm: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APEX_230100.WWV_FLOW_FORM_REGION", line 2306
ORA-06512: at "APEX_230100.WWV_FLOW_FORM_REGION", line 2156
ORA-06512: at "APEX_230100.WWV_FLOW_FORM_REGION", line 2348
ORA-06512: at "APEX_230100.WWV_FLOW_PROCESS_NATIVE", line 1379
ORA-06512: at "APEX_230100.WWV_FLOW_PLUGIN", line 3448
component.type: APEX_APPLICATION_PAGE_PROCESS
component.id: 9854072037356268
component.name: Initialize form Paises Divisione
association_type: REGION
region_id: 9847693345356252
error_backtrace:
ORA-06512: at "APEX_230100.WWV_FLOW_FORM_REGION", line 2306
ORA-06512: at "APEX_230100.WWV_FLOW_FORM_REGION", line 2156
ORA-06512: at "APEX_230100.WWV_FLOW_FORM_REGION", line 2348
ORA-06512: at "APEX_230100.WWV_FLOW_PROCESS_NATIVE", line 1379
ORA-06512: at "APEX_230100.WWV_FLOW_PLUGIN", line 3448
ORA-06512: at "APEX_230100.WWV_FLOW_PROCESS", line 191
When the detail block has only one row, I can see it, modify it, but not add any new row.
Any ideas? The page is as APEX creates it by default. I have not modified anything.
Thanks