Oracle 11g: step by step guide to send email via utl_smtp with all requirements from scratch (3 merged) [message #677647] |
Thu, 03 October 2019 02:06 |
oralover2006
Messages: 144 Registered: January 2010 Location: India
|
Senior Member |
|
|
hi all,
please help with any guide link where i can have step by step approach tutorial from scratch ( multiple recipients, multiple attachments from Oracle Directory etc.) which also guide for all types of requirements, setups etc. to send email through Oracle 11g 11.2.0.4 using utl_smtp package.
searched and found various but not a Complete from step 1 to last.
I have to give solution to one of our client ( which requires to send email via oracle job on daily basis )
thanks
|
|
|
Oracle 11g: step by step guide to send email via utl_smtp with all requirements from scratch [message #677648 is a reply to message #677647] |
Thu, 03 October 2019 02:08 |
oralover2006
Messages: 144 Registered: January 2010 Location: India
|
Senior Member |
|
|
hi all,
please help with any guide link where i can have step by step approach tutorial from scratch ( multiple recipients, multiple attachments from Oracle Directory etc.) which also guide for all types of requirements, setups etc. to send email through Oracle 11g 11.2.0.4 using utl_smtp package.
searched and found various but not a Complete from step 1 to last.
I have to give solution to one of our client ( which requires to send email via oracle job on daily basis )
thanks
|
|
|
Oracle 11g: step by step guide to send email via utl_smtp with all requirements from scratch [message #677649 is a reply to message #677647] |
Thu, 03 October 2019 02:11 |
oralover2006
Messages: 144 Registered: January 2010 Location: India
|
Senior Member |
|
|
hi all,
please help with any guide link where i can have step by step approach tutorial from scratch ( multiple recipients, multiple attachments from Oracle Directory etc.) which also guide for all types of requirements, setups etc. to send email through Oracle 11g 11.2.0.4 using utl_smtp package.
searched and found various but not a Complete -mostly are for old versions of Oracle DB- from step 1 to last.
I have to give solution to one of our client ( which requires to send email via oracle job on daily basis )
thanks
[Updated on: Thu, 03 October 2019 02:18] Report message to a moderator
|
|
|
|
Re: Oracle 11g: step by step guide to send email via utl_smtp with all requirements from scratch (3 merged) [message #677651 is a reply to message #677650] |
Thu, 03 October 2019 02:41 |
oralover2006
Messages: 144 Registered: January 2010 Location: India
|
Senior Member |
|
|
John Watson wrote on Thu, 03 October 2019 12:57What examples did you find? Perhaps it would be quicker for you to complete them (or ask the author to do so) rather than asking people here to start from nothing.
thank you sir for your reply.
i go through pages below, topics are old enough to ask from them.
https://stackoverflow.com/questions/41608282/send-email-with-pdf-attachment-with-pl-sql
https://stackoverflow.com/questions/7753457/pl-sql-send-email-with-attachment
https://community.oracle.com/thread/2221725
https://community.oracle.com/message/14003829
https://community.oracle.com/thread/3934115?start=0&tstart=0
thanks
EDIT: client also required to send emails to their clients outside company's domain ( sorry I forgot to mention it in OP )
[Updated on: Thu, 03 October 2019 03:02] Report message to a moderator
|
|
|
|
|
|
Re: Oracle 11g: step by step guide to send email via utl_smtp with all requirements from scratch (3 merged) [message #677664 is a reply to message #677658] |
Thu, 03 October 2019 23:40 |
oralover2006
Messages: 144 Registered: January 2010 Location: India
|
Senior Member |
|
|
John Watson wrote on Thu, 03 October 2019 23:46Ah. It does sound awfully like you are asking for a lot of coding, for free, that you can then sell to your client. Sorry! If you post an actual problem, perhaps someone will help.
dear, I already had code and tried, posted here in another topic http://orafaq.com/forum/t/206128/ and you have replied on it. I think there is some kind of problem with connecting to SMTP Server and I have to use another FREE SMTP service like MailGun etc. to give demo to my clients. I will create a new topic for it how to configure and use the same code in another topic.
thanks for your input.
[Updated on: Thu, 03 October 2019 23:48] Report message to a moderator
|
|
|