OraFAQ Forum: SQL & PL/SQL » PLS-00306: wrong number or types of arguments in call to 'PR

Home » SQL & PL/SQL » SQL & PL/SQL » PLS-00306: wrong number or types of arguments in call to 'PR_4552' (Oralce 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

PLS-00306: wrong number or types of arguments in call to 'PR_4552' [message #613123]

Wed, 30 April 2014 05:27

na.dharma@gmail.com
Messages: 82
Registered: May 2008
Location: bangalore

Member

Hi

I am getting the below error where i executing the procedure, can you please some one help me to resolve this error.

CREATE OR REPLACE PROCEDURE pr_4552(p_audit_key gt_value_arr)
AS
BEGIN
  FOR i IN 1 .. p_audit_key.COUNT
  LOOP
    dbms_output.put_line('Audit key = ' || p_audit_key(i));
  END LOOP;
END;

EXEC pr_4552(5455)

ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'PR_4552'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Report message to a moderator

Re: PLS-00306: wrong number or types of arguments in call to 'PR_4552' [message #613124 is a reply to message #613123]

Wed, 30 April 2014 05:28

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Error message means what it says, you're either passing the wrong number of parameters, or the parameters you are passing are the wrong datatype.
So what's gt_value_arr when it's at home?

Report message to a moderator

Re: PLS-00306: wrong number or types of arguments in call to 'PR_4552' [message #613126 is a reply to message #613123]

Wed, 30 April 2014 06:40

Solomon Yakobson
Messages: 3273
Registered: January 2010
Location: Connecticut, USA

Senior Member

Based on your code gt_value_arr is collection type. Therefor yopu need to use:

EXEC pr_4552(gt_value_arr(5455))

SY.

Report message to a moderator

Re: PLS-00306: wrong number or types of arguments in call to 'PR_4552' [message #613254 is a reply to message #613126]

Thu, 01 May 2014 12:32

dtechedu
Messages: 14
Registered: April 2009
Location: Bangalore

Junior Member

What is the definition of gt_value_arr? Is it a regular Collection or created using any PL/SQL pre-defined array datatype. Is it single dimensional or multi?

Report message to a moderator

Re: PLS-00306: wrong number or types of arguments in call to 'PR_4552' [message #613255 is a reply to message #613254]

Thu, 01 May 2014 12:38

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

There is no multidimensional array in PL/SQL.
In addition, it does not matter if the type is an array or not.

[Updated on: Thu, 01 May 2014 12:40]

Report message to a moderator

Re: PLS-00306: wrong number or types of arguments in call to 'PR_4552' [message #613256 is a reply to message #613254]

Thu, 01 May 2014 12:49

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

dtechedu wrote on Thu, 01 May 2014 23:02

What is the definition of gt_value_arr? Is it a regular Collection or created using any PL/SQL pre-defined array datatype. Is it single dimensional or multi?

Frankly speaking, how would anybody apart from you could know what does that collection is all about? You have the code source, we only have what you post.

Could you please copy paste the collection definition?

Report message to a moderator

Re: PLS-00306: wrong number or types of arguments in call to 'PR_4552' [message #613257 is a reply to message #613256]

Thu, 01 May 2014 12:58

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

dtechedu is not OP (na.dharma@gmail.com).

Report message to a moderator

Re: PLS-00306: wrong number or types of arguments in call to 'PR_4552' [message #613258 is a reply to message #613257]

Thu, 01 May 2014 13:03

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Gee...my bad...realized it now...thanks for correcting Michel...

Report message to a moderator

Re: PLS-00306: wrong number or types of arguments in call to 'PR_4552' [message #624898 is a reply to message #613255]

Sat, 27 September 2014 11:56

dtechedu
Messages: 14
Registered: April 2009
Location: Bangalore

Junior Member

Michel Cadot wrote on Thu, 01 May 2014 23:08

There is no multidimensional array in PL/SQL.
In addition, it does not matter if the type is an array or not.

Mutidirectional in the sense collection of records.

Report message to a moderator

Re: PLS-00306: wrong number or types of arguments in call to 'PR_4552' [message #624901 is a reply to message #624898]

Sat, 27 September 2014 12:02

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

dtechedu wrote on Sat, 27 September 2014 22:26

Mutidirectional in the sense collection of records.

Direction and dimesion are two different attributes Wink

Report message to a moderator

Re: PLS-00306: wrong number or types of arguments in call to 'PR_4552' [message #624902 is a reply to message #624898]

Sat, 27 September 2014 12:22

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

dtechedu wrote on Sat, 27 September 2014 18:56

Michel Cadot wrote on Thu, 01 May 2014 23:08

There is no multidimensional array in PL/SQL.
In addition, it does not matter if the type is an array or not.

Mutidirectional in the sense collection of records.

Multidimensional array and collection of records are really really different things.
I don't see the purpose to come back after almost 5 months to say that.

Report message to a moderator

Re: PLS-00306: wrong number or types of arguments in call to 'PR_4552' [message #624905 is a reply to message #624902]

Sat, 27 September 2014 13:39

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Michel Cadot wrote on Sat, 27 September 2014 18:22

Multidimensional array and collection of records are really really different things.
I don't see the purpose to come back after almost 5 months to say that.

Maybe it took him that long to figure out what he meant? Smile

Report message to a moderator

Previous Topic:	Package of Analyze Partitions
Next Topic:	Error with multi-dimenssional array.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 05:37:52 CDT 2024