Showing posts with label Missing IN or OUT parameter. Show all posts
Showing posts with label Missing IN or OUT parameter. Show all posts

Friday, May 11, 2012

Missing IN or OUT parameter at index:: 1 in Adf

java.sql.SQLException: Missing IN or OUT parameter at index:: 1 in Adf

If the bind variable property wrongly defined into VO then it will cause following exception

"java.sql.SQLException: Missing IN or OUT parameter at index:: 1 "

If the Bind Variable' s  required property wrongly defined into VO.Then this will lead to missing in or out exception.To prevent this exception following thing you have to keep in mind when you are creating new bind variable.

We can use bind variable following way in VO

1-Direct in query
2-or in the view criteria.

 1-If you are directly passing the bind variable in query then in this case bind variable require property should be selected 



2-or if you are creating view criteria then in this case the bind variable property should not be  selected



Thanks
Prateek