2

I am attempting to send an email using a sql procedure, and am getting some errors. Here is my relevant code:

   IF cur_email%FOUND THEN
stu_email := schema.get_person_email_adr(v_id);

 IF send_email = 'Y' THEN

UTL_MAIL.SEND (sender => v_email_from,     -- line of error
               recipients => stu_email,
               subject => v_email_subject,
               mime_type => 'text/html',
               message => v_email_body );
END IF;
END IF;

I will be getting multiple "v_id", and am trying to send an email to each one that I get, so I was also wondering if I am doing that correctly? The error that I am getting is this:

PLS-00201: identifier 'UTL_MAIL' must be declared

I am not sure why I am encountering this, Before I made some of these changes, I never received this error, so I believe that the utl_mail set up is not the problem.

Thanks!

Ollie
  • 17,058
  • 7
  • 48
  • 59
Mr Man
  • 1,498
  • 10
  • 33
  • 54
  • 2
    You are talking about utl_file, but yet your code shows utl_mail... –  Sep 27 '11 at 15:47

1 Answers1

4

UTL_MAIL is not installed by default, because it requires some configuring on the part of the sysadmin team. Find out more.

So, perhaps it has not been installed, or perhaps EXECUTE privilege on it has not been granted to your stored procedure owner.

APC
  • 144,005
  • 19
  • 170
  • 281
  • I had just come back to this page to mark my question as answered, because I didnt grant execute to my schema on the utl_mail package, haha. So, good timing, appreciate the help. – Mr Man Sep 27 '11 at 16:51