Name | Modified | Size | Downloads / 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 *