Home » SQL & PL/SQL » SQL & PL/SQL » Getting PLS: 00306 wrong number or types of arguments in call to (11.2.0.4)
Getting PLS: 00306 wrong number or types of arguments in call to [message #684575] Wed, 30 June 2021 23:10 Go to next message
kamaluv234
Messages: 2
Registered: June 2021
Junior Member
Hi All,
I am trying to create a pl/sql pkg, getting a "PLS-00306: wrong number or types of arguments in call to'CP_TABLE'" error, I am not sure where i missing, Can you pls help me to advice. Thanks !

SQL> @org_copy_main.sql

Package created.


Warning: Package Body created with compilation errors.

SQL> show error
Errors for PACKAGE BODY PRODDBA.PRESTOCOPYORGMAIN:

LINE/COL ERROR
-------- -----------------------------------------------------------------
207/25   PL/SQL: Statement ignored
207/25   PLS-00306: wrong number or types of arguments in call to
         'CP_TABLE'
Re: Getting PLS: 00306 wrong number or types of arguments in call to [message #684576 is a reply to message #684575] Thu, 01 July 2021 00:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Indent the code, use code tags and align the columns in result.

Check your parameters in the call to CP_TABLE.
For instance, "org_id" is declared as CHAR in CP_TABLE definition and as BOOLEAN in the procedure that calls it.

Re: Getting PLS: 00306 wrong number or types of arguments in call to [message #684577 is a reply to message #684575] Thu, 01 July 2021 00:18 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It is the ORG_ID parameter.

- in procedure CP_TABLE, it is declared as CHAR
- in procedure RUNCOPYORG (which calls CP_TABLE), it is declared as BOOLEAN
Re: Getting PLS: 00306 wrong number or types of arguments in call to [message #684578 is a reply to message #684576] Thu, 01 July 2021 00:25 Go to previous message
kamaluv234
Messages: 2
Registered: June 2021
Junior Member
Thanks a lot @Littlefoot @Michel Cadot, My bad, thanks for pointing out.
Previous Topic: two different counts in select
Next Topic: Issues with my Associative Array
Goto Forum:
  


Current Time: Thu Mar 28 09:02:57 CDT 2024