Apex 5.1 Interactive Grid Save Shows ORA-1403 No Data Found on Save When Select Statement Contains Where Clause
Last updated on DECEMBER 19, 2017
Applies to:Oracle Application Express (formerly HTML DB) - Version 5.1.1.00.08 to 5.1.3 [Release 5]
Information in this document applies to any platform.
The interactive grid throws the following error when saving updates in the interactive grid when the query is filtered using a page item:
Ajax call returned server error ORA-01403: no data found for .
This error can be reproduced using the EMP table with a source query of:
FROM emp WHERE :F_EXECUTE = 'EXECUTE' AND deptno = NVL (:F_DEPT, deptno);
Steps to reproduce:
1. Change Department field to SALES.
2. Click Search.
3. Update any row in the department column.
4. Click Save.
A different symptom can be seen with a source query of:
a.empno, a.ename, a.job, a.sal, a.comm, b.dname, b.loc
from emp a, dept b
and nvl(a.comm, 0) < 1000;
In this scenario the error occurs only if you enter a value greater than 1000.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms