Home » SQL & PL/SQL » SQL & PL/SQL » PL/SQL Procedure to send PDF File as attachment
PL/SQL Procedure to send PDF File as attachment [message #232320] Fri, 20 April 2007 02:26 Go to next message
prabhuapps
Messages: 79
Registered: June 2005
Location: Bangalore
Member
Hi ALL,

I have a requirment to send PDF file as attachement to mail id's.

I have one procedure to send Text file as attachement. But it is giving problem with PDF file.

Does any body have PL/SQL Procedure to send PDF file as attachment to mail id's?

Thanks in Advance

Regards,
Prabhu
Re: PL/SQL Procedure to send PDF File as attachment [message #232322 is a reply to message #232320] Fri, 20 April 2007 02:31 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
What threads did you find when you searched the board?

MHE
Re: PL/SQL Procedure to send PDF File as attachment [message #232357 is a reply to message #232320] Fri, 20 April 2007 04:37 Go to previous messageGo to next message
prabhuapps
Messages: 79
Registered: June 2005
Location: Bangalore
Member
The search returned some threads
1. which are directly sending the report output to mail id's
2. some are using JAVA
3. some are used send text files

Re: PL/SQL Procedure to send PDF File as attachment [message #232361 is a reply to message #232357] Fri, 20 April 2007 04:52 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
And did you find your answer?

I find this one interesting.

MHE

[Updated on: Fri, 20 April 2007 04:57]

Report message to a moderator

Re: PL/SQL Procedure to send PDF File as attachment [message #232362 is a reply to message #232320] Fri, 20 April 2007 04:59 Go to previous messageGo to next message
prabhuapps
Messages: 79
Registered: June 2005
Location: Bangalore
Member
No. I am searching for a PL/SQL Procedure which will accept the To address, file name(PDF) and location to send this file as attachment to that mail id.

Regards,
Prabhu
Re: PL/SQL Procedure to send PDF File as attachment [message #232364 is a reply to message #232362] Fri, 20 April 2007 05:12 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
As PL/SQL is executed on the server, you will first have to move the file to a location the server is aware of.

I've had a quick peek at http://forums.oracle.com and came across this thread. the maildemo_sql.txt is worth a look.

MHE
Re: PL/SQL Procedure to send PDF File as attachment [message #232365 is a reply to message #232320] Fri, 20 April 2007 05:22 Go to previous message
prabhuapps
Messages: 79
Registered: June 2005
Location: Bangalore
Member
Maaher,

I got it from metalink. Herewith I have Attached the procedure for others reference.

Thanks for your support.

Regards,
Prabhu
Previous Topic: multi table insert query
Next Topic: Bulk Collect Query
Goto Forum:
  


Current Time: Mon Dec 05 03:11:20 CST 2016

Total time taken to generate the page: 0.05854 seconds