Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ADF 11g:Missing IN or OUT parameter at index:: 1

Wendy TrompMar 3 2009 — edited Mar 9 2009
I have no custom code at all in my small project. I have one entity, and an updateable view on it. The updateable view has one bind variable, which is used in the where clause.
In the application module, locking is set to optimistic and the AMpooling is off. Still I cannot use executewithparams, I keep getting the error in the topic.

Even when I try to run the application module, the view won't initialize, i get the JBO 27122 error and the "Missing IN or OUT parameter at index:: 1 " error.

The documentation says this:

"To resolve either of these errors, double-check that the list of named bind variables in the SQL matches the list of named bind variables in the Bind Variables section of the overview editor's Query page for the view object. Additionally, open the Bind Variables dialog for the bind variable and verify that the Reference checkbox is not still deselected (the default). To use the bind variable in a SQL statement, you must select the Reference checkbox"

which is funny, because there is no such thing as a Reference checkbox in the Bind variables dialog.

What's the bug and how to solve it?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 6 2009
Added on Mar 3 2009
5 comments
615 views