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.

2 comments:

Abdul Rafey said...

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

regards
Abdul rafey

Unknown 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.