Home » Developer & Programmer » Forms » Attaching file in UTL_MAIL.send_attach_varchar2 (Forms 10g)
Attaching file in UTL_MAIL.send_attach_varchar2 [message #442254] Sat, 06 February 2010 01:41 Go to next message
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
Re: Attaching file in UTL_MAIL.send_attach_varchar2 [message #442317 is a reply to message #442254] Sat, 06 February 2010 22:06 Go to previous messageGo to next message
tamzidulamin
Messages: 132
Registered: October 2009
Location: Dhaka
Senior Member
Please search this forum with "EMAIL".
Re: Attaching file in UTL_MAIL.send_attach_varchar2 [message #442332 is a reply to message #442317] Sun, 07 February 2010 00:22 Go to previous message
tamzidulamin
Messages: 132
Registered: October 2009
Location: Dhaka
Senior Member
Please see the following link:

http://www.orafaq.com/wiki/Send_mail_from_PL/SQL

Tamzidul Amin.
Previous Topic: How to Use CheckBox Is Checked All In Block by button
Next Topic: Email using Outlook Express from forms 10g
Goto Forum:
  


Current Time: Wed Dec 07 03:20:46 CST 2016

Total time taken to generate the page: 0.07614 seconds