The blog for hints & tips about Oracle Application Development Framework and Mobile Application Framework

  • ADFbc
    February 29, 2012

The infamous Missing IN or OUT parameter error

Frank Nimphius
Master Principal Product Manager

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.

Join the discussion

Comments ( 1 )
  • saurabh Saturday, April 14, 2018
    I am Facing Error "Missing IN or OUT parameter at index:: 7"
    can any body please guide
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.