DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: UTL_MAIL package configure/install

Threaded View

  1. #5
    Join Date
    Jul 2003
    Posts
    136
    I am still unable to send emails using the package

    Earlier the error on using

    begin
    -- Call the procedure
    utl_mail.send('[email protected]','[email protected]');
    end;

    was
    ---------
    error Message: ORA-20001: Failed to send mail due to the following error: ORA-29261: bad argument
    ORA-20001: Failed to send mail due to the following error: ORA-29261: bad argument
    ---------

    now after I have inistalized the parameter

    smtp_out_server = ww01.int.a.com:25, b.int.a.com:25, ww02.int.a.com:25 SCOPE=both;

    the message I am getting is
    --------
    Failed to send mail due to the following error: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
    ORA-20001: Failed to send mail due to the following error: ORA-06502: PL/SQL: numeric or value error: character to number conversion error
    --------

    Send procedure takes following parameters out of which only the first 2 are required - precipients & pcc

    procedure send(precipients varchar2,
    pcc varchar2,
    pbcc varchar2,
    psubject varchar2,
    pmessage varchar2,
    pmime_type varchar2, -- Default 'text/plain;
    ppriority pls_integer, -- Default NULL
    pexc boolean);

    I could not find any help on web. Please help.

    -D
    Last edited by daljitsb; 08-02-2006 at 11:56 AM.

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