Home » SQL & PL/SQL » SQL & PL/SQL » PLS-00306: wrong number or types of arguments in call to
PLS-00306: wrong number or types of arguments in call to [message #236724] Thu, 10 May 2007 13:12 Go to next message
tgrams
Messages: 2
Registered: May 2007
Location: Montreal
Junior Member
I keep on getting the same error
PLS-00306: wrong number or types of arguments in call to 'VENDOR_LOOP'
and can't seem to figure out why since the number of parameters I am passing is equal to the number of IN parameters the stored procedure is accepting and it seems to be in the right order.
here is my call

vendor_loop(p_checkrun_name,
p_vendor_type,
p_vendor_id,
p_start_payment_date,
p_end_payment_date,
p_invoice_detail
p_set_of_books_id, p_fax_to_supplier, REC_VENDOR_SITE);
and here is the start of my procedure

PROCEDURE vendor_loop (
errbuf OUT VARCHAR2 ,
retcode OUT NUMBER ,
p_checkrun_name IN VARCHAR2,
p_vendor_type IN VARCHAR2,
p_vendor_id IN NUMBER,
p_start_payment_date IN DATE,
p_end_payment_date IN DATE,
p_invoice_detail IN VARCHAR2,
p_set_of_books_id IN NUMBER,
p_order_by IN VARCHAR2,
p_fax_to_supplier IN VARCHAR2,
REC_VENDOR_SITE IN po_vendor_sites_all%ROWTYPE)

If anybody can help me out I would really appreciate it.
thanks
Re: PLS-00306: wrong number or types of arguments in call to [message #236728 is a reply to message #236724] Thu, 10 May 2007 13:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If this is not the number may it is the type but Oracle is surely right.

Regards
Michel
Re: PLS-00306: wrong number or types of arguments in call to [message #236729 is a reply to message #236724] Thu, 10 May 2007 13:53 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
You are using positional rather than named parameters, so position is important. Aslo - to avoid confusion, try uning input parameter variables with different names to the parameters.

vendor_loop (
--errbuf => v_errbuf,
--retcode => v_retcode ,
p_checkrun_name => v_checkrun_name,
p_vendor_type => v_vendor_type,
p_vendor_id => v_vendor_id,
p_start_payment_date => v_start_payment_date,
p_end_payment_date => v_end_payment_date,
p_invoice_detail => v_invoice_detail,
p_set_of_books_id => v_set_of_books_id,
--p_order_by => v_order_by,
p_fax_to_supplier => v_fax_to_supplier,
REC_VENDOR_SITE => v_REC_VENDOR_SITE);
Re: PLS-00306: wrong number or types of arguments in call to [message #236774 is a reply to message #236724] Fri, 11 May 2007 00:14 Go to previous message
shankar muthusamy
Messages: 21
Registered: November 2006
Location: singapore
Junior Member
you need to pass the variable for out parameter to capture the values while call the procedure
Previous Topic: Problems creating an object VIEW that returns multiple rows from a BLOB datatype
Next Topic: pl/sql tuning
Goto Forum:
  


Current Time: Mon Dec 05 13:15:44 CST 2016

Total time taken to generate the page: 0.09738 seconds