René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Java and Oracle

JServer Option

The Oracle JServer Option is a Java Virtual Machine that can be embedded into the Oracle Server. If it is installed, it allows to write Java stored procedures.

ORA-29547: Java system class not available: oracle/aurora/rdbms/Compiler

This error indicates that JServer has not been loaded. This can be made up leeway through executing the script initjvm.sql in SQL*PLUS:
SQL> @?/javavm/install/initjvm
dba_registry shows if the Java VM is installed:
SQL> select comp_id from dba_registry ;

COMP_ID
------------------------------
CATALOG
CATPROC
XDB
JAVAVM
This installation must be performed as SYS.
When initjvm is called, the init parameter shared_pool_size must apparantly be set to at least 24M.

Examples

The following three examples demonstrate Java stored procedures: