Tuesday, October 23, 2012

java.sql.SQLException: Attempt to set a parameter name that does not occur in the SQL: Variable

There should not be any Bind variables defined in View Object if it is not used in SQL Query.

To remove the Bind Variables from the View Object.

1.Go to Edit view Object.-->Bind Variables
2.Select any variable defined and select remove button.

3 comments:

Abdul Rafey said...

hi,
how if we use the bind variable in view criteria.

regards
Abdul rafey

Sridevi Koduru said...

I am Sridevi Koduru, Senior Oracle Apps Trainer With 8 Yrs Exp on Oracle Apps and 13 Yrs IT Exp Providing Online Training on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Apps SCM, Oracle Apps HRMS, Oracle Financial for Indian Localization, SQL, PL/SQL and D2K. I have Provided Training for 500+ Professionals Most of them are Working in Real Time now.

Contact for (One to One Personal Online Training) on Oracle Apps Technical, Oracle Apps Financial Functional, Oracle Financial for Indian Localization, Oracle Apps SCM, Oracle Apps HRMS, SQL, PL/SQL and D2K at training@oracleappstechnical.com or sridevikoduru@oracleappstechnical.com | +91-9581017828 | http://www.oracleappstechnical.com

Linkedin profile - http://in.linkedin.com/pub/sridevi-koduru/8b/76a/9b8/

John S John said...

Thanks a lot. In my case I had a bind variable which had default value and that value was only used in query. I substituted the use of bind variable directly with the value and removed the bind variable.