Home » SQL & PL/SQL » SQL & PL/SQL » send pdff
send pdff [message #445336] Sun, 28 February 2010 22:48 Go to next message
Messages: 2
Registered: August 2008
Location: islamabad
Junior Member
I want to send pdf as attachment having size grater than 32kb using mail_demo package how can i do this.i used utl_mail package for sending files less then 32kb but i want to use utl_smtp package
Re: send pdff [message #445337 is a reply to message #445336] Sun, 28 February 2010 22:59 Go to previous messageGo to next message
Messages: 25570
Registered: January 2009
Location: SoCal
Senior Member
>i want to use utl_smtp package
UTL_SMTP was first introduced in V8.1.6 & has limited capabilities.
If you insist on using UTL_SMTP then you have to code up your own capability to do any attachment & also overcome the PL/SQL string limit of 32K.

Good Luck with your Quest.

[Updated on: Sun, 28 February 2010 23:00]

Report message to a moderator

Re: send pdff [message #445362 is a reply to message #445336] Mon, 01 March 2010 03:19 Go to previous message
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
if you are using UNIX os then,write Shell to send email with Attachement and call the script in Oracle.

[Updated on: Mon, 01 March 2010 03:20]

Report message to a moderator

Previous Topic: Ref Cursors
Next Topic: Help in making query
Goto Forum:

Current Time: Fri Aug 18 09:43:53 CDT 2017

Total time taken to generate the page: 0.15420 seconds