This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,010 Users
  • 2,269,775 Discussions
  • 7,916,823 Comments

Discussions

SQLException: Missing IN or OUT parameter at index:: 2

User_BMQ12
User_BMQ12 Member Posts: 30 Green Ribbon

Hey everybody! I am creating an app in jdeveloper version 12.2.1.0.0

When the sql request is executed, there is such an error in the logs. Help, I can not understand what is the problem?


Tagged:

Best Answers

  • Timo Hahn
    Timo Hahn Senior Principal Consultant Cologne, GermanyMember, Moderator Posts: 39,055 Red Diamond
    Answer ✓

    Can you tell us your exact JDev version, please?

    Your query has two parameters, :p_zipcode_cur and :p_index.

    The log tells you that only one parameter having the value of 220051, was given. As the second parameter is missing, you get the error from the SQL execution.

    Check where the query is called and pass the second parameter. This should fix the error.


    Timo

    User_BMQ12
  • User_BMQ12
    User_BMQ12 Member Posts: 30 Green Ribbon
    Answer ✓

    @Timo Hahn Thank you, it resolve the problem!

Answers

  • Timo Hahn
    Timo Hahn Senior Principal Consultant Cologne, GermanyMember, Moderator Posts: 39,055 Red Diamond
    Answer ✓

    Can you tell us your exact JDev version, please?

    Your query has two parameters, :p_zipcode_cur and :p_index.

    The log tells you that only one parameter having the value of 220051, was given. As the second parameter is missing, you get the error from the SQL execution.

    Check where the query is called and pass the second parameter. This should fix the error.


    Timo

    User_BMQ12
  • User_BMQ12
    User_BMQ12 Member Posts: 30 Green Ribbon
    Answer ✓

    @Timo Hahn Thank you, it resolve the problem!