I am expereiencing an annoying production problem, Invild email address:
ERROR at line 1:
ORA-29279: SMTP permanent error: 501 5.1.3 Invalid address
ORA-06512: at "SYS.UTL_SMTP", line 21
ORA-06512: at "SYS.UTL_SMTP", line 99
ORA-06512: at "SYS.UTL_SMTP", line 241
ORA-06512: at "SATURN_MIDD.STU_A_AAP", line 1324
ORA-06512: at "SATURN_MIDD.STU_A_AAP", line 7514
ORA-06512: at line 2
I have like 80 emails retrieve in a cursor, I put all the emails in a software (Key Survey software) to validate the emails all of them came on as a valid emails, I checked one by one, I even send an email in outlook to all of them as a test, no one bounce, so I don't know what else to do here, this piece of code have been working for years..
I changed this 'smtp.xxxxx.edu',
'aap@xxxx.edu',
all the xxxx (my changes for this posting)
for this posting
The chair_email is coming from a cursor
IF chair_email IS NOT NULL
THEN
p_send_email
('smtp.xxxxx.edu',
'aap@xxxx.edu',
'' || receiver_email || '',
'aap@xxxx.edu',
'' || chair_email || '',
'Interview Assignment Alert',
'Dear Alumni Admissions volunteer,'
|| CHR (13)
|| ''
|| CHR (13)
|| 'Thank you for your participation in the Alumni Admissions Program. You have been assigned the following student to contact, ideally within the next couple of weeks. If the student lives within an hour''s drive of your home, then a face to face interview would be the preferred method of contact. If further away, please free to complete the contact with the student by phone or email. To submit your interview comments, please go to the Alumni Admissions web site at http://www.middlebury.edu/alumni/volunteering/admissions, follow the "restricted site" link and sign in with your Middlebury ID number ('
|| mem_id
|| ') and password. The Admissions Office looks forward to receiving your input about this applicant by '
|| int_due
|| '.'
|| CHR (13)
|| ''
|| CHR (13)
|| 'Thank you. If there are any problems with this assignment, please don''t reply to the email address above. Instead, contact me directly at my own email address which is: '
|| chair_email
|| ' . '
|| CHR (13)
|| ''
|| CHR (13)
|| 'Sincerely,'
|| CHR (13)
|| chair_first
|| ' '
|| chair_last
|| CHR (13)
|| 'AAP Committee Chairperson'
|| CHR (13)
|| ''
|| CHR (13)
|| ''
|| CHR (13)
|| 'ID #:'
|| i.sybiden_id
|| CHR (13)
|| i.sybiden_last_name
|| ', '
|| i.sybiden_first_name
|| CHR (13)
|| i.syraddr_street_line1
|| CHR (13)
|| i.syraddr_city
|| CHR (13)
|| i.syraddr_stat_code
|| ', '
|| i.syraddr_zip
|| CHR (13)
|| i.syraddr_phone_formatted
|| CHR (13)
|| i.goremal_email_address
|| CHR (13)
|| 'Application Type: '
|| app_type_desc
|| ''
);
ELSIF chair_email IS NULL
THEN
p_send_email
('smtp.xxxx.edu',
'aap@xxxxx.edu',
'' || receiver_email || '',
'aap@xxxx.edu',
'aap@xxxx.edu',
'Interview Assignment Alert',
'Dear Alumni Admissions volunteer,'
|| CHR (13)
|| ''
|| CHR (13)
|| 'Thank you for your participation in the Alumni Admissions Program. You have been assigned the following student to contact, ideally within the next couple of weeks. If the student lives within an hour''s drive of your home, then a face to face interview would be the preferred method of contact. If further away, please free to complete the contact with the student by phone or email. To submit your interview comments, please go to the Alumni Admissions web site at http://www.xxxxx.edu/alumni/volunteering/admissions, follow the "restricted site" link and sign in with your Middlebury ID number ('
|| mem_id
|| ') and password. The Admissions Office looks forward to receiving your input about this applicant by '
|| int_due
|| '.'
|| CHR (13)
|| ''
|| CHR (13)
|| 'Thank you. If there are any problems with this assignment, please don''t reply to the email address above. Instead, contact me directly at my own email address which is: '
|| chair_email
|| ' . '
|| CHR (13)
|| ''
|| CHR (13)
|| 'Sincerely,'
|| CHR (13)
|| chair_first
|| ' '
|| chair_last
|| CHR (13)
|| 'AAP Committee Chairperson'
|| CHR (13)
|| ''
|| CHR (13)
|| ''
|| CHR (13)
|| 'ID #:'
|| i.sybiden_id
|| CHR (13)
|| i.sybiden_last_name
|| ', '
|| i.sybiden_first_name
|| CHR (13)
|| i.syraddr_street_line1
|| CHR (13)
|| i.syraddr_city
|| CHR (13)
|| i.syraddr_stat_code
|| ', '
|| i.syraddr_zip
|| CHR (13)
|| i.syraddr_phone_formatted
|| CHR (13)
|| i.goremal_email_address
|| CHR (13)
|| 'Application Type: '
|| app_type_desc
|| ''
);
END IF;
END IF;