Questions tagged [utl-mail]
19 questions
0
votes
1 answer
utl_mail procedure compiling but email not arriving
I'm trying to send emails from oracle db through utl_mail package. i installed it, granted permissions to user etc.
Since i dont have a comercial email server, im using a gmail account, and in order to authenticate i am running an email relay…
S.H.
- 183
- 9
0
votes
1 answer
Oracle add new line character to varchar variable for utlmail message
I am creating the body of an email for utlmail and I want to create a string and replace tokens in the string. The first problem I am having is displaying new lines in the body of the email.
Mesg VARCHAR2(4000) := q'[Item1:token1 /n/n…
Jason Smith
- 373
- 2
- 6
- 20
0
votes
1 answer
Can I use smstp.gmail.com as mail server in UTL_MAIL?
I want to send mail using UTL_MAIl package in Oracle 11g. It is possible to use "smtp.gmail.com" google imap server as my SMTP server for this? please help?
BEGIN
EXECUTE IMMEDIATE 'ALTER SESSION SET smtp_out_server =…
leosheran
- 39
- 7
-4
votes
1 answer
send email from stored procedure
i need to send email via oracle database pl/sql, the stored procedure must including authentication (username/password)
Joseph Hassan
- 1
- 2