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
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 )
can any body please guide