René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
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:
|