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


1 comment:

  1. Hi Prateek,

    I am using ADF and recently I had to modify an existing viewobject to contain 3 bind variables which I could set a runtime to get the exact row. I have set some default values for the bind variables which will return 0 rows. Since modifying this in production random customers get Missing in or out parameters at index 1. Why is this happening.