OraFAQ Forum: Forms » Attaching file in UTL_MAIL.send_attach

Home » Developer & Programmer » Forms » Attaching file in UTL_MAIL.send_attach_varchar2 (Forms 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Attaching file in UTL_MAIL.send_attach_varchar2 [message #442254]

Sat, 06 February 2010 01:41

abdulahads
Messages: 44
Registered: October 2009
Location: SAUDI

Member

File asd.txt not getting atatched to mail.

DECLARE
rfile VARCHAR2(4000);
BEGIN
baninst1.UTL_MAIL.send_attach_varchar2(
sender => 'abc@yahoo.com',
recipients => :sprmail.sprmbox_stu_email,
cc => null,
bcc => null,
subject => 'Information Regarding Mail Box System' ,
message => 'This is the Mail Box Information',
mime_type => 'text; charset=us-ascii',
priority => 3,
attachment => rfile,
att_inline => FALSE,
att_mime_type=> 'application/octet',
att_filename => 'asd.txt');
EXCEPTION
WHEN OTHERS THEN
MESSAGE('An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM);
END;

Thanks

Report message to a moderator