Missing IN or OUT parameter at index: 1(Resolved)

Here is the resolution for the error ‘Missing IN or OUT parameter at index: 1’. It annoyed me when I tried to execute a query in SQL Developer. I did a Google search for this, but I did not get the right solution. I am sharing the solution of how I resolved.

Table of contents

1. Resolution for the error Missing IN or OUT
2. Conclusion

Get Srinimf’s E-books for Complex SQL queries, DB2 tough interview questions and more.

Resolution for the error Missing IN or OUT

I have executed the SQL query, which caused the error “Missing IN or Out”.

SELECT DEPT_NO, EMPLOYEE_ID 
FROM EMPLOYEE
WHERE DEPT_NO = '1'
AND DATE_OF_JOIN = '20_OCT_2019';

I got an error ‘Missing IN or OUT parameter at index: 1. I researched the root cause. The reason is a problem with the index parameters given in the WHERE clause.

I have double-checked. I found that the DATE format is not correct (found ‘underscore’ in the DATE). So the SQL Developer is not recognizing the string and throws an error. So we always need to give a ‘dash’ in the DATE.

AND DATE_OF_JOIN = '20-OCT-2019';

So finally, for these kinds of errors, verify the index fields given in the WHERE clause.

Podcast

Audio: How to Resolve IN and OUT Index Error

Conclusion

In conclusion, the “Missing IN or OUT parameter at index: 1” error in SQL Developer can often be attributed to incorrect index parameters or formatting issues, particularly with date fields. When encountering this error, it is important to carefully verify the index fields provided in the WHERE clause to ensure correct syntax and formatting. By addressing these issues, users can effectively resolve this error and successfully execute their SQL queries in SQL Developer.

References

• Missing IN or OUT parameter at index:: 1 IBM Solution