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
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
Thanks
Prateek
Hi Prateek,
ReplyDeleteI am using ADF 10.1.3.2 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.