Often error messages like "attempt to set a parameter
name that does not occur in the SQL" and "Missing IN or OUT parameter
at index" are caused by developers mixing required and optional bind
variables in their SQL queries WHERE clause. If you used bind variables in ADF
Business Components SQL queries, make sure the bind variables are set to required. Bind variables that are
marked as optional are only good to be used in View Criterias.
In a future version of Oracle JDeveloper, the two bind
variable types (the optional ones used in View Criteria and the required ones
used in the context of SQL queries) are visually separated in the layout of the
View Object editor.
can any body please guide