Re: email

From: Pascal Byrne <nospam-byrne_at_icada.net>
Date: Mon, 23 Sep 2002 09:55:29 +0200
Message-ID: <ammhdh$758ph$1@ID-147008.news.dfncis.de>

This could be a socket permission problem with the Jserver. Try the following replacing SCOTT with your username:

begin

   dbms_java.grant_permission(

         grantee => 'SCOTT',
         permission_type => 'java.net.SocketPermission',
                 permission_name => '*',
                 permission_action => 'connect,resolve'

);
end;
/

Magne wrote:
> Hi
>
> Someone who knows what to do to be able to send email from Oracle (version
> 8.1.7)?
>
> I have created a procedure with call to the UTL_SMTP package...
> But if i test my procedure it only returns an error:
> ORA-20001: 421 Service not available
>
> Magne
>
>
>
>
Received on Mon Sep 23 2002 - 02:55:29 CDT