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

I have resolved the error ‘ Missing IN or OUT parameter at index: 1’. Which 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.

SQL Query

SELECT DEPT_NO, EMPLOYEE_ID 
FROM EMPLOYEE
WHERE DEPT_NO = '1'
AND DATE_OF_JOIN = '20-OCT-2019';

I got 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 not recognizing the string and throws an error. So We always need to give ‘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.

Reference

Related Posts

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.