java.sql.SQLException: Missing IN or OUT parameter at index:: 1 with ADF BC

While creating the search forms in the ADF using ADF BC, we are creating the bind variable in the view object.

Some times the bind variable is not created properly, and causes the exception, java.sql.SQLException: Missing IN or OUT parameter at index:: 1


There are two options that bind variable is required for developing ADF Search forms from ADF BC.

1. Search Form created from 'Execute with Params ' operation - Direct Query

In this case, bind variables 'required' property shoud be selected.

2. Search Form created from view criteria.

In this case, bind variables 'required' property should not be selected.