SQL & PL/SQL

Hi there,

long time ago beeing here for asking a question;-)

I want to get Mails from a Mail Server and use the Package MAIL_CLIENT

Source:
http://plsqlmailclient.sourceforge.net


When I execute this command in the APEX sql command box


"

begin
mail_client.connect_server(
p_hostname => 'Name Mail Server.de',
p_port => 143,
p_protocol => mail_client.protocol_IMAP,
p_userid => 'name of user',
p_passwd => ''
);
end;

"

the following error appears:

ORA-29532: Java call terminated by uncaught Java exception: javax.mail.AuthenticationFailedException


In SQL*Plus the following error appears:

FEHLER in Zeile 1:
ORA-29532: Java-Aufruf durch nicht abgefangene Java-Exception beendet:
javax.mail.AuthenticationFailedException
ORA-06512: in "schema_name.MAIL_CLIENT", Zeile 5
ORA-06512: in "schema_name.MAIL_CLIENT", Zeile 34
ORA-06512: in Zeile 2



Package MAIL_CLIENT:
create or replace package mail_client authid current_user as
PROTOCOL_IMAP constant varchar2(4) := 'imap';
PROTOCOL_POP3 constant varchar2(4) := 'pop3';

procedure connect_server (
p_hostname in varchar2,
p_port in number,
p_protocol in varchar2,
p_userid in varchar2,
p_passwd in varchar2,
p_ssl in boolean default false
);

function is_connected return number;
function get_shared_namespaces return mail_array_ct;
function get_folders return mail_array_ct;
procedure open_inbox;
procedure open_folder(p_folder in varchar2);
procedure close_folder;
procedure expunge_folder;

procedure disconnect_server;

function get_mail_headers return mail_ct;
function get_mail_headers_p return mail_ct pipelined;
function get_message(p_message_number in number) return mail_t;
function rfc_decode(p_text in varchar2) return varchar2;
procedure create_folder(p_foldername in varchar2) ;
procedure delete_folder(p_foldername in varchar2) ;
procedure rename_folder(p_foldername in varchar2, p_new_foldername in varchar2);
procedure open_parent_folder;
procedure open_child_folder(p_foldername in varchar2);
function get_folder_fullname return varchar2;
function get_folder_name return varchar2;
end mail_client;



I think the parameters p_hostname, p_port and p_protocol are correct. The password is not set and in my oppinion therefor the
parameter setting of p_passwd => '' is correct. But I am not sure.


It is Oracle 11g R2 and APEX 4.1

Can anybody help me please?

Thanks!