PLS_00306 Error: wrong number or type of arguments in call to send_emails.
Hi,
I have a procedure in a package pqrs_batch_utilities.
PROCEDURE send_emails( i_subject IN VARCHAR2,
i_message IN VARCHAR2) AS
v_i_from_who VARCHAR2(35) := 'NRS_BATCH_LOAD@PQRS.NET';
v_i_to_who VARCHAR2(200) := 'THOMAS@PQRS.NET,JONES@PQRS.NET,RAYMOND@PQRS.NET';
v_i_cc VARCHAR2(80) := 'DEBRA@PQRS.NET,JOEY@PQRS.NET,ROSS@PQRS.NET';
v_i_bcc VARCHAR2(2) :='';
BEGIN
utl_mail.send(sender => v_i_from_who,
recipients => v_i_to_who,
cc => v_i_cc,
bcc => v_i_bcc,
subject => i_subject,
message => i_message);
END send_emails;
When trying to call the procedure with the following arguments from other packages like
pqrs_batch_utilities.send_emails(i_subject => 'Automated Fee Processing ',
i_message => 'Fee Files generated successfully at ' ||TO_CHAR(SYSDATE,'HH:MI AM')||' on '|| TO_CHAR(SYSDATE,'DD-MON-YYYY'));
I AM GETTING THE ERROR
PLS_00306 Error: wrong number or type of arguments in call to send_emails.
Can anybody please help me?
Thanks