Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Getting error wrong number or type of argument in call to create_project

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
-
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
-
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.
-
We have been passing the same variable as way the standard api is invoked but still getting error
-
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?