Home » Developer & Programmer » Forms » wrong number or types of arguments in call to function
wrong number or types of arguments in call to function [message #589088] Tue, 02 July 2013 03:09 Go to next message
mist598
Messages: 904
Registered: February 2013
Location: Hyderabad
Senior Member
Hi,

I wrote function Quantity(p_item_number in varchar2)RETURN NUMBER, i called This function in POST_QUERY ,Error like this "wrong number or type of arguments in call to Quantity", i tried like as " Quantity(p_item_number in varchar2)RETURN NUMBER" , but it gives an error "encounterd the symbol VARCHAR2 when expecting one of the following ( "..

Can any one help me plesase?

Thanks&Regards,
Siva
Re: wrong number or types of arguments in call to function [message #589089 is a reply to message #589088] Tue, 02 July 2013 03:10 Go to previous messageGo to next message
Littlefoot
Messages: 19520
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How exactly did you call the function? Copy/paste that line over here.
Re: wrong number or types of arguments in call to function [message #589094 is a reply to message #589089] Tue, 02 July 2013 03:24 Go to previous messageGo to next message
mist598
Messages: 904
Registered: February 2013
Location: Hyderabad
Senior Member
:RHCLANDEDCOSTDET.ONHANDQUANTITY := xxc_onhand_quantity(p_item_number);
Re: wrong number or types of arguments in call to function [message #589096 is a reply to message #589094] Tue, 02 July 2013 03:25 Go to previous messageGo to next message
cookiemonster
Messages: 10922
Registered: September 2008
Location: Rainy Manchester
Senior Member
xxc_onhand_quantity is not same as quantity.
Post the correct declaration of the function you are calling.
Re: wrong number or types of arguments in call to function [message #589097 is a reply to message #589096] Tue, 02 July 2013 03:28 Go to previous messageGo to next message
Littlefoot
Messages: 19520
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
On the right hand of the := sign, you don't pass "p_item_number" to a function - it is the parameter name. You have to pass its actual value, such as '2' or '1234' or 'ABC1234' or whatever (possibly a form item value, such as :block.item_name).
Re: wrong number or types of arguments in call to function [message #589098 is a reply to message #589096] Tue, 02 July 2013 03:28 Go to previous messageGo to next message
mist598
Messages: 904
Registered: February 2013
Location: Hyderabad
Senior Member
Ok,

I called function"BLOCKNAME.COLUMNAME:= xxc_onhand_quantity(p_item_number in varchar2) return number;

Thanks,
Re: wrong number or types of arguments in call to function [message #589099 is a reply to message #589097] Tue, 02 July 2013 03:30 Go to previous message
mist598
Messages: 904
Registered: February 2013
Location: Hyderabad
Senior Member
yes i got it..

Thanks Littlefoot.. Smile
Previous Topic: browser support
Next Topic: Find an error line in PLSql
Goto Forum:
  


Current Time: Thu Aug 28 11:08:32 CDT 2014

Total time taken to generate the page: 0.11165 seconds