Filtered Table Fails with Error "Attempt to set a parameter name that does not occur in the SQL" the First Time When the Preset Filtered Value is Changed (Doc ID 1205386.1)

Last updated on AUGUST 04, 2016

Applies to:

Oracle JDeveloper - Version 11.1.1.2.0 and later
Information in this document applies to any platform.

Symptoms

When there is a View Criteria that is set to "Query Automatically" option in the UI hints, and show the result of this VC in a filtered ADF table, after the initial correct display of the filtered values on the table, with the next change of the filter value and re-filtering of the table, only the first time an error like the following is experienced:

SQL error during statement preparation. Statement: SELECT Emp.EMPNO, Emp.ENAME, Emp.JOB, Emp.MGR, Emp.HIREDATE, Emp.SAL, Emp.COMM, Emp.DEPTNO
FROM EMP Emp WHERE ( ( (Emp.DEPTNO = :vc_temp_2 ) ) )
Error
Attempt to set a parameter name that does not occur in the SQL: vc_temp_1


Cause

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