How to import custom java jar/class into oracle to be used in java proc ?
336471Jan 24 2007 — edited Feb 1 2007Hi
I would like to know how to import custom java jar/class files into oracle to be used in
java stored procedure.
I am developing a oracle pl/sql procedure to call java program. The java program will be
created as procedure and will be published.
But, my question is that I do have a other external jar/class file that need to be imported
into this java program.
example
-------
raise_sal.java
--------------
import java.util.*;
import oracle.sql.*;
import cmpmsgsvc.xxxx.* ;
import cmpmsgsvc.yyyy.* ;
import cmpmsgsvc.zzzz.* ;
...........
............
............
-----------
how do I import the cmpmsgsvc jar/class file into oracle so that I don't have any
compilation errros on raise_sal.java program ??
what are the steps to import/compile and validate to do this?
thanks for your help in advance.
Thanks
rrb.