Use oracle's own UTL_SMTP package to send mail-CodePudding

Use Oracle's own UTL_SMTP package send mail, the rest of the email such as @ 163. com can success
But QQ mailbox send not success, the wrong SMTP 535 Error please use the authorization code in
(note: I use the landing is the authorization code is always in authentication codes that line the error)
Mand UTL_SMTP.com

For the great god, the great god,

CodePudding user response:

Different email certification rules, had to help others test records, basically see v_user part

 - the following four variables, please according to the actual mail server assignment 
V_mailhost VARCHAR2 (30) :='smtpcom.263xmail.com'. - the SMTP server address 
 v_user VARCHAR2 (30) :='[email protected]'. - log in SMTP server user name; Just a username, not including 163. com part, this is a wrong way, to see whether the mail system certification rules  
V_pass VARCHAR2 (20) :='XXXXXX'; - log in SMTP server password 
V_sender VARCHAR2 (50) :='[email protected]'. - send email, general and ps_user corresponding 
V_conn UTL_SMTP. Connection; - links to the mail server 
V_msg varchar2 (4000); - email content

CodePudding user response:

reference 1st floor jdsnhan response:

the mailbox certification rules, had to help others test records, basically see v_user part

 - the following four variables, please according to the actual mail server assignment 
V_mailhost VARCHAR2 (30) :='smtpcom.263xmail.com'. - the SMTP server address 
 v_user VARCHAR2 (30) :='[email protected]'. - log in SMTP server user name; Just a username, not including 163. com part, this is a wrong way, to see whether the mail system certification rules  
V_pass VARCHAR2 (20) :='XXXXXX'; - log in SMTP server password 
V_sender VARCHAR2 (50) :='[email protected]'. - send email, general and ps_user corresponding 
V_conn UTL_SMTP. Connection; - links to the mail server 
V_msg varchar2 (4000); - email content

This I write so, 163 can be successful, qq
You don't succeed,

CodePudding user response:

Certification rules, qq mailbox rule:
Open the POP3/SMTP, IMAP function first why you need to set up independent password?
Open the POP3/SMTP, IMAP function must first set up independent password, it can protect you in the third party client login account security,
If you have open the function of POP3/SMTP, IMAP, cancel the independent password will also shut down your POP3/SMTP, IMAP function, which can lead to you can't be in the third party client landing QQ mailbox,
The solution: reset password independently,