CRITICAL SKILL 7.4

Java in Oracle

The Java runtime environment contains the JVM, the Java runtime class libraries, JDBC, SQLJ, and a Java application launcher. Oracle Database 10g is a deployment environment, not a development environment. Java code should be created in a Java development tool such as Oracle JDeveloper 10g. The appropriate Java files should then be loaded into the Oracle database.

Once the Oracle JVM option is configured, Java-stored procedures can be executed using JDBC and SQLJ. The Oracle JVM also uses a PL/SQL package DBMS_JAVA. Be aware that Java names can exceed the SQL identifier length. The database allows a Java name to be up to 4000 characters in length. If a Java name (long name) exceeds the maximum SQL identifier ...

Get Oracle Database 10g: A Beginner's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.