Call java from stored procedure
921096Aug 21 2012 — edited Aug 21 2012Hi all,
We have a stored procedure named proc_java_test
From this stored proc, we need to call a java class named java_test.java
This class posts messages to a queue hosted on an app server running on a separate box.
create or replace
PROCEDURE PROC_JAVA_TEST
(
num IN NUMBER
)
AS LANGUAGE JAVA
NAME 'java_test.post(int) ';
Is it mandatory to place java files in oracle_home/bin ?
I tried placing the file on some other location and then calling it from stored proc. It did not work.
Can we point oracle to read java file from location other than oracle_home/bin?
Oracle version used: 11.2.0.2r3
Regards
Manisha