PLS_00306 Error: wrong number or type of arguments in call to send_emails.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

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

  1. #1
    Join Date
    Nov 2007
    Posts
    1

    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

  2. #2
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    Some problem with the concatenation it seems . I guess 'HH:MI AM' should also have || operator.
    http://www.perf-engg.com
    A performance engineering forum

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width