We are trying to call java code from PL/sql.
We tried it on a simple helloworld program. We loaded the program into
orale 8.1.5 using loadjava, and it worked fine and printed out the
values.
Next we are trying a simple program to insert values into a table (the
primary interest being the CLOB column). That program works fine
standalone.
Now when we load it into oracle and try to run it through PL/SQL, it is
giving java.lang.NullPointerException. The scenario is:
- The class which implements the public methods. (for simplicity of
testing all methods do not have any parameters)
- The wrapper class which has a static method which instantiates the
above class and calls the method on the above class. This is the entry
point for the PL/SQL procedure.
Thanks in advance..you can also send a reply directly to
chirdeep_at_hotmail.com
Chirdeep.