OraFAQ Forum: Forms » wrong number or types of arguments in call to function

Home » Developer & Programmer » Forms » wrong number or types of arguments in call to function

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

wrong number or types of arguments in call to function [message #589088]

Tue, 02 July 2013 03:09

mist598
Messages: 1195
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

Report message to a moderator

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

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

How exactly did you call the function? Copy/paste that line over here.

Report message to a moderator

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

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

:RHCLANDEDCOSTDET.ONHANDQUANTITY := xxc_onhand_quantity(p_item_number);

Report message to a moderator

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

cookiemonster
Messages: 13963
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.

Report message to a moderator

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

Littlefoot
Messages: 21823
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).

Report message to a moderator

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

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Ok,

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

Thanks,

Report message to a moderator

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

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

yes i got it..

Thanks Littlefoot.. Smile

Report message to a moderator

Previous Topic:	browser support
Next Topic:	Find an error line in PLSql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 19:00:35 CST 2025