Home » SQL & PL/SQL » SQL & PL/SQL » Oracle 11g: step by step guide to send email via utl_smtp with all requirements from scratch (3 merged) (Oracle DB, v.11.2.0.4)
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 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 #677650 is a reply to message #677647] Thu, 03 October 2019 02:27 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Quote:
searched and found various but not a Complete -mostly are for old versions of Oracle DB- from step 1 to last.
What 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.
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 Go to previous messageGo to next message
oralover2006
Messages: 144
Registered: January 2010
Location: India
Senior Member
John Watson wrote on Thu, 03 October 2019 12:57
What 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 #677653 is a reply to message #677651] Thu, 03 October 2019 04:53 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Some of those examples look pretty good. Where did they go wrong?
Re: Oracle 11g: step by step guide to send email via utl_smtp with all requirements from scratch (3 merged) [message #677656 is a reply to message #677653] Thu, 03 October 2019 06:09 Go to previous messageGo to next message
oralover2006
Messages: 144
Registered: January 2010
Location: India
Senior Member
John Watson wrote on Thu, 03 October 2019 15:23
Some of those examples look pretty good. Where did they go wrong?
no, i am not claiming that they are wrong, instead i want a complete guide from initial setup to final test... each and every step like on a newly installed DB 11g now want to setup to send email through UTL_SMTP. i think its clear now, sorry for any inconvenience.
Re: Oracle 11g: step by step guide to send email via utl_smtp with all requirements from scratch (3 merged) [message #677658 is a reply to message #677656] Thu, 03 October 2019 13:16 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Ah. 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.
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 Go to previous message
oralover2006
Messages: 144
Registered: January 2010
Location: India
Senior Member
John Watson wrote on Thu, 03 October 2019 23:46
Ah. 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

Previous Topic: Co-related Subquery Throwing Error While Using rank function
Next Topic: question on using materialized view that will be based on table having billions of rows
Goto Forum:
  


Current Time: Thu Mar 28 05:32:54 CDT 2024