i created a basic simple form based on a table, i have created manually an Automatic Row Fetch Process on it, to retrieve an existing data.
ORA-01403: no data found
Technical Info (only visible for developers)
- is_internal_error: false
- ora_sqlcode: 100
- ora_sqlerrm: ORA-01403: no data found
- component.type: APEX_APPLICATION_PAGE_PROCESS
- component.id: 22609023275144779
- component.name: Fetch Row from DEPT
error_backtrace:
ORA-06512: at line 1 ORA-06512: at "SYS.DBMS_SQL", line 1575 ORA-06512: at "APEX_050100.WWV_FLOW_DYNAMIC_EXEC",
line 1879 ORA-06512: at "APEX_050100.WWV_FLOW_DYNAMIC_EXEC", line 1894 ORA-06512: at "APEX_050100.WWV_FLOW_DYNAMIC_EXEC",
line 935 ORA-06512: at "APEX_050100.WWV_FLOW_PROCESS_NATIVE", line 71 ORA-06512: at "APEX_050100.WWV_FLOW_PROCESS_NATIVE",
line 1132 ORA-06512: at "APEX_050100.WWV_FLOW_PLUGIN", line 2397 ORA-06512: at "APEX_050100.WWV_FLOW_PROCESS", line 191
error_statement:
- begin SELECT DEPTNO , DNAME , LOC INTO :P10_DEPTNO , :P10_DNAME , :P10_LOC FROM DEPT WHERE DEPTNO = :P10_DEPTNO ; end;
If i use this i got no error but no data displays
Please help me.