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

Thread: UTL_MAIL package configure/install

Hybrid View

  1. #1
    Join Date
    Jul 2003
    Posts
    136

    Question UTL_MAIL package configure/install

    Environment: Oracle 10g (10.1.0.2.0) standard edition on Windows 2003 server

    I need to install utl_mail package and this is the link I am working with http://download-east.oracle.com/docs...802/u_mail.htm

    The link above asks says:

    ------------------------
    Operational Notes
    You must both install UTL_MAIL and define the SMTP_OUT_SERVER.

    To install UTL_MAIL:
    sqlplus sys/
    SQL> @$ORACLE_HOME/rdbms/admin/utlmail.sql
    SQL> @$ORACLE_HOME/rdbms/admin/prvtmail.sql


    You define the SMTP_OUT_SERVER parameter in the init.ora rdbms initialization file. However, if SMTP_OUT_SERVER is not defined, this invokes a default of DB_DOMAIN which is guaranteed to be defined to perform appropriately.
    --------------------------

    I successfully ran and installed utlmail.sql, but the issue is I don't see prvtmail.sql file exist but only prvtmail.plb. So how do I run SQL> @$ORACLE_HOME/rdbms/admin/prvtmail.sql
    to install SMTP_OUT_SERVER.

    Please help.

    -D

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    run the plb file

  3. #3
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    I think you can run the file directly..

    SQL> @$ORACLE_HOME/rdbms/admin/prvtmail.plb

    Could be a document error!
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  4. #4
    Join Date
    Jul 2003
    Posts
    136
    Thanks. Direc t running @$ORACLE_HOME/rdbms/admin/prvtmail.plb
    works.

    -D

  5. #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('user@company.com','user@company.com');
    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