Stack Overflow
Stack Overflow

Questions tagged [utl-mail]

19 questions
2
votes
1 answer

Error using UTL_MAIL in a SQL procedure

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 =>…
Mr Man
  • 1,498
  • 10
  • 33
  • 54
2
votes
2 answers

execute immediate oracle string concatenate issue

I am having issues concatenating a string to be called be execute immediate. Anybody have any idea what is wrong with the following statement below. EXECUTE IMMEDIATE 'ALTER SESSION SET smtp_out_server = ''||SMTPServer||'''; select smtpserver into…
Jason Smith
  • 373
  • 2
  • 6
  • 20
1
vote
1 answer

error: 553 sorry, that domain isn't in my list of allowed rcpthosts

I want send the email from oracle database. So I did the following steps @F:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\utlmail.sql @F:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\prvtmail.plb alter system set smtp_out_server = 'webmail.vilsoft.co.in:25'…
Bahirji Naik
  • 175
  • 1
  • 2
  • 16
1
vote
1 answer

Exceptions regarding utl_mail.send()

I am sending emails using utl_mail.send(), and it is possible that some of the people that come through my cursor will not have email address's or will have invalid emails. I am having trouble finding out what exceptions I can use to make sure that…
Mr Man
  • 1,498
  • 10
  • 33
  • 54
1
vote
1 answer

ORACLE PL/sql SEND_ATTACH_VARCHAR2 the first line of the attachment is empty

I need to send email with csv attachment. Im trying to use UTL_MAIL.SEND_ATTACH_VARCHAR2 and its working, but first row is always empty. (contains CRLF). How to remove this empty row? Why does Oracle put CRLF characters on the first line? Thanks…
Keliimek
  • 155
  • 1
  • 1
  • 10
1
vote
1 answer

How to send pl/sql procedure status through an email?

I have scheduled a PL/SQL procedure. I want to send the status of the PL/SQL procedure (whether it is successful or has any error messages) to my email address. I saw some ways of sending pre-defined templates of emails using UTL_MAIL. But how can I…
Rmd90
  • 97
  • 4
1
vote
1 answer

How Can I Send Emails in PL/SQL (Oracle)?

I have a procedure which count the number of rows in SMS_OUTBOX table and send emails if its row cont is over 1000. My procedure is given below: CREATE OR REPLACE PROCEDURE SEND_EMAIL_ABOUT_PENDING_SMS IS CHECK_SMS_COUNT NUMBER := 1000; …
user10606387
0
votes
1 answer

Email Table Style seems not to work for Outlook (send via UTL_Mail)

I want to generate an email including some table data and use PLQL to send this to company members. So far I am using some HTML templates and Oracles UTL_mail. I did send emails to a Gmail web interface and to Outlook. As the style seems okay in…
Peter Frey
  • 361
  • 4
  • 17
0
votes
3 answers

Trying to send multiple bcc in oracle UTL_MAIL

I am trying to send multiple email addresses through an Oracle package/procedure. I have the procedure working when sending only a single to, cc, bcc. (That means I can send one of each.) But although have a loop that generates a correct, single…
amackley
  • 3
  • 1
0
votes
0 answers

Send Image (jpg/png) as an attachment to mail | UTL_MAIL

I am stuck not getting how do I send mail with Image as an attachment via UTL_MAIL I am uploading the attachment to below table via ORACLE APEX 20.x Table : my_attachment create table my_attachment ( my_file_clob blob, mimetype varchar2(255…
yyy62103
  • 81
  • 5
0
votes
1 answer

Oracle 18c XE utl_mail: ORA-24247 although user and host are listet in ace

I had to upgrade our database from oracle 11g to oracle 18c XE. In 11g some scheduled jobs send emails to report database errors or report errors in the data. The user SYS ist able to send emails via the defined smtp_out_server but not the user…
Chris
  • 23
  • 4
0
votes
0 answers

Sending Email in PLSQL using UTL_MAIL throwing SMTP Parmanent Error : 550 RBL - Oracle 11g

I want to send newly inserted entries of audit table through EMAIL along with newly inserted data in CSV format. I am using after insert trigger to keep track of inserted rows, but my code is unable to send email. It's throwing error ORA-29279 :…
Sumaiya Qureshi
  • 31
  • 9
0
votes
0 answers

ERROR in calling UTL_MAIL procedures

I am trying to send mails through UTL_MAIL. where I used below code: declare v_sender VARCHAR2(30); v_recipients VARCHAR2(60); v_subj VARCHAR2(20); v_msg VARCHAR2(200); begin v_sender := 'abc@xyz.com'; v_recipients := 'aaa@xyz.com'; v_subj :=…
Sumant GK
  • 300
  • 2
  • 8
0
votes
1 answer

Send .csv file as attachment through UTL_MAIL.Send

I have a file on local drive let's say C:\test\att.csv. I had configured PL/SQL procedure to gather data from database and send an email. The att.csv file contains some values which I have send as an attachment of the email. Can you please help me…
Kaushal Dave
  • 1
  • 3
0
votes
1 answer

oracle utl_mail smtp authentication issue

I'm trying to setup UTL_MAIL through Oracle to email users regarding account deactivation's. Below is what i've done so far - Installed the package - @utlmail.sql & @prvtmail.plb Set smtp parameter - ALTER SYSTEM SET smtp_out_server =…
phemor
  • 299
  • 6
  • 17
1
2