Oracle Database 10g: A Beginner's Guide

CRITICAL SKILL 7.3

Configure Java for Oracle

The Oracle JVM must be configured and installed to run Java in Oracle Database 10g. The core Java classes, including the JDBC (Java Database Connectivity APIs) and SQLJ (embedded SQL for Java) classes are all natively compiled for performance. Once the Oracle JVM is installed, Java-stored procedures can be executed in the Oracle database, but they must be configured separately on the middle and client tiers. During the database installation, a large number of Java classes are loaded into Oracle Database 10g.

SQL> CONNECT / AS SYSDBA
SQL> SELECT count(*) FROM dba_objects WHERE object_type = 'JAVA CLASS';
 COUNT (*)
----------
     15681

The Oracle Database Configuration Assistant can also be used for installing ...