How can i install java on an existing XE database so that java stored programs can be run
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.