Home » RDBMS Server » Server Administration » DB Admin-UTL_MAIL.SEND execution
DB Admin-UTL_MAIL.SEND execution [message #271808] Wed, 03 October 2007 01:09 Go to next message
dba_giri
Messages: 26
Registered: July 2007
Location: Hyderabad
Junior Member
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.
Re: DB Admin-UTL_MAIL.SEND execution [message #271812 is a reply to message #271808] Wed, 03 October 2007 01:13 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

utlmail.sql +prvtmail.plb
Re: DB Admin-UTL_MAIL.SEND execution [message #271813 is a reply to message #271808] Wed, 03 October 2007 01:13 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Are you sure utl_mail is installed?
2/ Are you sure you get access to it directly or via PUBLIC?
3/ "WHEN OTHERS THEN raise_application_error(-20001,'The following error has occured: ' || sqlerrm);"
is quite stupid, remove this and you'll get the same thing plus the line where the error occured, information you lose with "when others"

Regards
Michel
Previous Topic: tablespace location on hard disk
Next Topic: can't migrate from dictionary to locally managed
Goto Forum:
  


Current Time: Sat Dec 03 22:06:23 CST 2016

Total time taken to generate the page: 0.11001 seconds