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 MARCH 18, 2019
Applies to:Oracle JDeveloper - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
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 ... FROM ... WHERE ( ( (<FIELD> = :vc_temp_2 ) ) )
Attempt to set a parameter name that does not occur in the SQL: vc_temp_1
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document