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

Thread: DB Admin-UTL_MAIL.SEND execution

  1. #1
    Join Date
    Jul 2007
    Location
    India
    Posts
    21

    DB Admin-UTL_MAIL.SEND execution

    Hi..,

    I 've executed all the following scripts after created the DB(using DBCA) :
    $oracle_home\rdbms\admin\catalog.sql at sysdba
    $oracle_home\rdbms\admin\catproc.sql at sysdba
    $oracle_home\sqlplus\admin\pupbld.sql at system user

    Is there any scripts are required to execute for the following requirement

    I 've tried to create a procedure as follows:
    CREATE OR REPLACE PROCEDURE send_email AS
    BEGIN
    UTL_MAIL.SEND(sender => 'xxx@yahoo.com', recipients => 'xxx@yahoo.com', cc => 'xxx@yahoo.com', bcc => 'xxx@yahoo.com', subject => 'Testmail', message => 'Hello');
    EXCEPTION
    WHEN OTHERS THEN
    -- dbms_output.put_line('Fehler');
    raise_application_error(-20001,'The following error has occured: ' || sqlerrm);
    END;
    /

    But, am getting the following error while creating it

    PLS-00201: identifier 'UTL_MAIL.SEND' must be declared


    Thanks in Advance
    Giri K.Y.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    does utl_mail exist in your database?

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