-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|