Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UTL_SMTP.TRANSIENT_ERROR how i can resolve this issue?

594221Oct 12 2010 — edited Oct 13 2010
create or replace
PROCEDURE send_mail_attach AS
BEGIN
UTL_MAIL.SEND_ATTACH_VARCHAR2(
sender => 'Junaid@matrix.com',
recipients => 'Junaid@matrix.com',
subject => 'Attachment Test Mail',
message => 'This is just a test mail with attachment.',
attachment => 'C:\',
att_filename => 'FED.txt');
EXCEPTION
WHEN UTL_SMTP.INVALID_OPERATION THEN
dbms_output.put_line(' Invalid Operation in Mail attempt using UTL_SMTP.');
WHEN UTL_SMTP.TRANSIENT_ERROR THEN
dbms_output.put_line(' Temporary e-mail issue - try again');
WHEN UTL_SMTP.PERMANENT_ERROR THEN
dbms_output.put_line(' Permanent Error Encountered.');
WHEN OTHERS THEN
RAISE_APPLICATION_ERROR(-20001,'The following error has occurred: ' || sqlerrm);
END;

EXECUTE send_mail_attach

how i can resolve this issue any body can help me plz......
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 10 2010
Added on Oct 12 2010
13 comments
2,432 views