-
1. Re: Possibilities to Receive an Email into Oracle Database
Pierre Yotti Mar 13, 2018 6:34 AM (in response to Srinivas medamdravu)1 person found this helpful -
2. Re: Possibilities to Receive an Email into Oracle Database
jariola Mar 13, 2018 7:55 AM (in response to Srinivas medamdravu)1 person found this helpfulYou should have some email address that receive emails.
And solution depend where that address mailbox is hosted.
I have not tested this, but check if this helps
PL/SQL Email Client API (Package MAIL_CLIENT)
If mailbox you like read is Gmail, then you can use Gmail RESTful API.
-
3. Re: Possibilities to Receive an Email into Oracle Database
Srinivas medamdravu Mar 14, 2018 9:04 AM (in response to Pierre Yotti)Thank you Alli for addressed to my query.
-
4. Re: Possibilities to Receive an Email into Oracle Database
Srinivas medamdravu Mar 14, 2018 9:10 AM (in response to jariola)Thank you jariola for addressed to my query.finally we got a point from you that we must have the mail server to receive mails into our Database.
it is Not possible without mail server right? please Confirm..
-
5. Re: Possibilities to Receive an Email into Oracle Database
jariola Mar 14, 2018 12:24 PM (in response to Srinivas medamdravu)1 person found this helpfulSrinivas medamdravu wrote:
Thank you jariola for addressed to my query.finally we got a point from you that we must have the mail server to receive mails into our Database.
it is Not possible without mail server right? please Confirm..
You need to have mailbox in some mail server.
It totally depend what you like to do and what you mean with receiving emails to database.
-
6. Re: Possibilities to Receive an Email into Oracle Database
Srinivas medamdravu Mar 15, 2018 10:54 AM (in response to jariola)Ok jariola.
Thank you..
-
7. Re: Possibilities to Receive an Email into Oracle Database
Billy~Verreynne Mar 15, 2018 11:35 AM (in response to Srinivas medamdravu)1 person found this helpfulSrinivas medamdravu wrote:
is there any Possibility to Receive Mails into Oracle Database without Mail Server.
No. The Oracle RDBMS does not contain an embedded mail server, like it does an embedded web server, via XDB.
Oracle mail send, using UTL_MAIL or UTL_SMTP or APEX mail, communicates SMTP (Simple Mail Transfer Protocol) to a mail server.
Oracle mail receive can be done via UTL_TCP using the POP3 (Post Office Protocol v3) or IMAP (Internet Message Access) protocol. Mail servers also support other client mail reader interfaces. MAPI for example is an old Windows API. SOAP and REST interfaces may be supported via HTTP(S).
Access to a mail server is mandatory in this case.
-
8. Re: Possibilities to Receive an Email into Oracle Database
Srinivas medamdravu Mar 15, 2018 2:46 PM (in response to Billy~Verreynne)Thank you Billy..
we got full Clarity with your answer..