Forum Stats

  • 3,838,702 Users
  • 2,262,394 Discussions
  • 7,900,739 Comments

Discussions

Getting error wrong number or type of argument in call to create_project

User_T60SA
User_T60SA Member Posts: 2 Red Ribbon

Hi team,

when compiling package which is invoking standard api pa_project_pub.create_project it throws an error wrong number or type of argument in call to create_project

Thanks!!

Best Answer

  • Robert Angel
    Robert Angel Member Posts: 4,535 Bronze Crown
    edited Jan 10, 2018 7:48AM Answer ✓

    Hi,

    the error is fairly self-explanatory, you are calling the package, but when you call it either;

    a. You do not have the same number of parameters (say - it expects 3 parameters and you have only provided 2)

    or

    b. You do not have the right kind of parameters (say - it expects 2 numeric and you provide 1 numeric, 1 varchar2)

    So check the package declaration of pa_project_pub.create_project and double check what you are feeding in in the call to the procedure in your package.

Answers

  • Robert Angel
    Robert Angel Member Posts: 4,535 Bronze Crown
    edited Jan 10, 2018 7:48AM Answer ✓

    Hi,

    the error is fairly self-explanatory, you are calling the package, but when you call it either;

    a. You do not have the same number of parameters (say - it expects 3 parameters and you have only provided 2)

    or

    b. You do not have the right kind of parameters (say - it expects 2 numeric and you provide 1 numeric, 1 varchar2)

    So check the package declaration of pa_project_pub.create_project and double check what you are feeding in in the call to the procedure in your package.

  • Saubhik
    Saubhik Member Posts: 5,805 Gold Crown
    edited Jan 10, 2018 7:52AM

    Oracle EBS forum is the best place for your question. This place is more towards general SQL, PL/SQL questions.  

  • User_T60SA
    User_T60SA Member Posts: 2 Red Ribbon
    edited Jan 10, 2018 7:54AM

    We have been passing the same variable as way the standard api is invoked but still getting error

  • Robert Angel
    Robert Angel Member Posts: 4,535 Bronze Crown
    edited Jan 10, 2018 8:38AM

    And are the variables DECLARED as the same type?

    Post your code please and an excerpt of the package declaration of the procedure you are calling.

    Also are you explicitly passing the variables p_in_one => v_in_one, etc rather than relying on order based?

This discussion has been closed.