Home » Developer & Programmer » Forms » Wrong number or type of arugment call in funciton (Forms 6i)
Wrong number or type of arugment call in funciton [message #393919] Tue, 24 March 2009 23:28 Go to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Hi
i have below code in when-list-changed

If :Replst = 'PVTREP' Then
	Declare
		  Type Param_table is table of varchar2(50) index by Binary_Integer;
		  Ptable Param_table;
	Begin
	
	        :sqltext := 'SELECT .....';	 
                                
         Fetch_pack.Fetch_param(:sqltext,Ptable);
     End;

End if


But I got the following error

wrong number or types of arguments in call to  'FETCH_PARAM'


Package Section

PACKAGE Fetch_Pack IS
  Type Param_table is table of Varchar2(50) index by Binary_Integer;
  Procedure Fetch_Param (sqltxt in out Char,Ptable Out Param_table);
END;


How to solve this issue please help me.

Kanish

[Updated on: Wed, 25 March 2009 00:00]

Report message to a moderator

Re: Wrong number or type of arugment call in funciton [message #394001 is a reply to message #393919] Wed, 25 March 2009 05:28 Go to previous messageGo to next message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
In form:

Declare
  Ptable Fetch_Pack.Param_table;
Begin


Don't declare another matching type in form, just type your array to the existing type in the package.
Re: Wrong number or type of arugment call in funciton [message #394255 is a reply to message #393919] Thu, 26 March 2009 05:33 Go to previous message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Thanks You.

Kanish

Previous Topic: help in this Procedure Parameters
Next Topic: report problem
Goto Forum:
  


Current Time: Thu Dec 08 22:30:33 CST 2016

Total time taken to generate the page: 0.14813 seconds