PLS_00306 Error: wrong number or type of arguments in call to send_emails.

[riya]

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

[malay_biswal]

Some problem with the concatenation it seems . I guess 'HH:MI AM' should also have || operator.