Home » SQL & PL/SQL » SQL & PL/SQL » Send Attachment in Email using PL/SQL (oracle 10g)
Send Attachment in Email using PL/SQL [message #422434] Wed, 16 September 2009 07:47 Go to next message
abhijitsj
Messages: 6
Registered: September 2009
Location: Pune
Junior Member
Hi all,


i am facing a problem for sending an attachment in email.

I have an GUI through which i am going to select the file from my local machine.

If the file will be on database server then its working. But not for the local machine

please help.


GUI jsp / Java
Re: Send Attachment in Email using PL/SQL [message #422435 is a reply to message #422434] Wed, 16 September 2009 07:51 Go to previous messageGo to next message
ThomasG
Messages: 3184
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Since PL/SQL runs on the Server, the file has to be on the server for it to work.

When you have the file on the client, it would be easier to send the file with the client. Do you know about javax.mail?

Another option would be: Upload the file into a temporary BLOB on the database.

[Updated on: Wed, 16 September 2009 07:57]

Report message to a moderator

Re: Send Attachment in Email using PL/SQL [message #422437 is a reply to message #422435] Wed, 16 September 2009 07:58 Go to previous messageGo to next message
abhijitsj
Messages: 6
Registered: September 2009
Location: Pune
Junior Member
Actually a PL/SQL procedure is sechedule for sending mails.
Using JAva it is little bit of difficult. Also it needs manual intrruption to invoke the proc. May be some session problem will come.
Re: Send Attachment in Email using PL/SQL [message #422439 is a reply to message #422435] Wed, 16 September 2009 08:00 Go to previous messageGo to next message
abhijitsj
Messages: 6
Registered: September 2009
Location: Pune
Junior Member
Thanks i will try this option
Re: Send Attachment in Email using PL/SQL [message #422440 is a reply to message #422437] Wed, 16 September 2009 08:01 Go to previous message
Michel Cadot
Messages: 63801
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Anyway, PL/SQL only works with local files (or rather files locally accessible).

Regards
Michel
Previous Topic: ORA-06550: PLS-00394: wrong number of values in the INTO list of a FETCH statement
Next Topic: Getting BULK In-BIND error during bulk update.
Goto Forum:
  


Current Time: Sun Sep 25 02:35:12 CDT 2016

Total time taken to generate the page: 0.19791 seconds