OraFAQ Forum: SQL & PL/SQL » UTL

Home » SQL & PL/SQL » SQL & PL/SQL » UTL_SMTP

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

UTL_SMTP [message #606235]

Tue, 21 January 2014 07:05

Aydin
Messages: 4
Registered: January 2014
Location: Baku

Junior Member

Hi,
I need send email with attachment -excel file and body of message must be HTML text . Please help how I can do it?
Thanks in advance.

Report message to a moderator

Re: UTL_SMTP [message #606236 is a reply to message #606235]

Tue, 21 January 2014 07:06

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Oracle version?

Report message to a moderator

Re: UTL_SMTP [message #606237 is a reply to message #606236]

Tue, 21 January 2014 07:15

Aydin
Messages: 4
Registered: January 2014
Location: Baku

Junior Member

11g

Report message to a moderator

Re: UTL_SMTP [message #606240 is a reply to message #606237]

Tue, 21 January 2014 07:35

gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK

Senior Member

What is the output from the following query?

SQL> SELECT * FROM V$VERSION;

[Edit: typo]

[Updated on: Tue, 21 January 2014 07:36]

Report message to a moderator

Re: UTL_SMTP [message #606241 is a reply to message #606235]

Tue, 21 January 2014 07:37

Aydin
Messages: 4
Registered: January 2014
Location: Baku

Junior Member

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Solaris: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

Report message to a moderator

Re: UTL_SMTP [message #606242 is a reply to message #606241]

Tue, 21 January 2014 07:41

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/u_mail.htm#ARPLS384

Report message to a moderator

Re: UTL_SMTP [message #606244 is a reply to message #606242]

Tue, 21 January 2014 08:00

Aydin
Messages: 4
Registered: January 2014
Location: Baku

Junior Member

I need create summary report in body of email as table (text/html) and attach detail report as xls file to email (text/plain).

Report message to a moderator

Re: UTL_SMTP [message #606245 is a reply to message #606244]

Tue, 21 January 2014 08:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/u_mail.htm#ARPLS71208

Report message to a moderator

Re: UTL_SMTP [message #606246 is a reply to message #606244]

Tue, 21 January 2014 08:05

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Yes, then use UTL_MAIL BlackSwan pointed you to; it supports attachment.

(Note an attached xls file is not a text/plain.)

Report message to a moderator

Previous Topic:	Issue in Database Link
Next Topic:	Passing bind variables to a VIEW

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 22:44:35 CDT 2024