asked on

Can you Help me to Read Mail using PL/SQL

i have custom Mail Server. i want to reed my email using pl/sql Procedure. i am trying with MAIL_CLIENT Package but facing issue with Host name and Not connecting.
Can you help me with any Option to Read Mail using pl/sql.

SOLUTION

Mark Geerlings

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Pradeep komari

ASKER

Hi,

MAIL_CLIENT Contains Java Methods to Fetch the Data from Mail Server.
Link: http://plsqlmailclient.sourceforge.net/apidoc/index.html
in that we have a Method initially to connect/ Login to the Server from Back end.
i.e.
mail_client.connect_server(
p_hostname => 'mailserver.mydomain.com',
p_port => 143,
p_protocol => mail_client.protocol_imap,
p_userid => 'user.name@mailserver.com',
p_passwd => '***',
p_ssl => false
);
Not Connecting:
We are getting errors as (Unknown Host name, Network Not Reachable, No Route To Host Exception) So, that we are finding Other way to fetch the Data from Mail Server.

Thanks,
Pradeep.

SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Pradeep komari

ASKER

Yes slightwv, i granted the permissions and i am trying this from admin User..

in between i tried in other way i.e.
build a Mail Server in Cloud instance.
in the Same instance i added Database, in that database i installed Mail_Clint Package and tried connecting.
with this scenario we solved the Unknown Host issue but we are facing Another issue i.e. "ORA-29532: Java call terminated by uncaught Java exception: javax.mail.AuthenticationFailedException: [PRIVACYREQUIRED] Plaintext authentication disallowed on non-secure (SSL/TLS) connections. " while running the Procedure Connect Server.

can you Explain me what Exactly we need to do to setup network ACLs: dbms_network_acl_admin.

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Pradeep komari

ASKER

Thank you slightwv.

we tried that option Already but we need certificates for that. it checks the certificates at that time.
than we get another type of error like "No Certificates found.."

Pradeep komari

ASKER

we got the correct Solution from other source.
Actually the problem is located at Mail Server configuration in Linux.
we don't have the parameter "ssl" in configuration file.
we must declare that parameter as no for this type of error.

Thank you all.