Hi,

You should have a mail server. Have a look here

How to configure apex with gmail for sending mail

https://asgor.net/how-to-send-mail-from-oracle-apex/

You 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.

Srinivas 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.

Srinivas 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.