Download Latest Version plsql_mail_client.1.1.5.zip (54.1 kB)
Email in envelope

Get an email when there's a new version of Mail Client API for Oracle PL/SQL

Name Modified Size InfoDownloads / Week
Parent folder
FAQ.txt 2014-05-26 3.2 kB
README.txt 2014-05-26 1.6 kB
CHANGELOG.txt 2014-05-26 3.2 kB
plsql_mail_client_1.1.4.zip 2014-05-26 54.5 kB
Totals: 4 Items   62.5 kB 0
* README.txt
* 
* DESCRIPTION:
*    Information and installation instructions for the package MAIL_CLIENT
*
* AUTHOR:
*    Carsten Czarski (carsten.czarski@gmx.de)
*
* PREREQUISITES:
*    Oracle Database 10.2.0.1 or higher
*    Java in the database must be installed and enabled
*    -----------------------------------------------------------------------
*      SQL> select comp_name, version from dba_registry where comp_name like '%JAVA%'
*
*      COMP_NAME                                VERSION
*      ---------------------------------------- ------------------------------
*      JServer JAVA Virtual Machine             10.2.0.1.0
*    -----------------------------------------------------------------------
*     
*    Appropriate "java_pool_size" setting; at least 50MB 
*  
*  PRIVILEGES REQUIRED:
*  The DB user which uses the package and the package owner need appropriate Java privileges
*  in order to connect to the mailserver. These privileges are to be granted
*  by a DBA user with the following command:
*
*  begin
*    dbms_java.grant_permission(
*      grantee           => '[dbuser]',
*      permission_type   => 'SYS:java.net.SocketPermission',
*      permission_name   => '[mailserver name or "*" for the whole network]',
*      permission_action => 'connect,resolve'
*    );
*  end;
*
* INSTALLATION PROCDEDURE:
*    SQL> start install.sql
*
* PROCEDURE FOR PUBLISHING THE PACKAGE TO ALL USERS 
* Note: Java network privileges are still required
*    SQL> start grantPublic.sql 
* 
* DEINSTALLATION STEPS:
*    SQL> start uninstall.sql
* 


Source: README.txt, updated 2014-05-26