Database Utilities (MOSC)

MOSC Banner

How can i install java on an existing XE database so that java stored programs can be run

edited Jun 28, 2013 1:46AM in Database Utilities (MOSC) 1 commentAnswered
Hi All,
I have a Oracle XE Database and now i would like to run java procedure from this oracle database.
On googling i got to know that JVM needs to be installed and the steps are listed out.

1.As SYS, confirm the JVM is not already installed.

SELECT comp_id, comp_name FROM dba_registry; should not list JAVAM or CATJAVA.
 
2.As SYS, perform the JVM installation.

 ◦@?/javavm/install/initjvm.sql
 ◦@?/rdbms/admin/catjava.sql
 
3.As SYS, confirm the JVM is now fully installed:


But the question is i do not find the .sql file to execute.
When i executed the first select statement , i could see that JVM is not installed.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center