O'Reilly logo

Oracle Database 10g: A Beginner's Guide by Michael Corey, Michael Abbey, Ian Abramson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required