Re: Running java code from PL/SQL

The priveledges javasyspriv and javauserpriv control the Oracle JVM sandbox environment. By granting these priveledges to the user that compiles the code (using LOADJAVA or CREATE JAVA CLASS) prior to the actual loading of the Java class files.

I went through the same thing when I was creating an interface with another system on the Internet.

rls

chirdeep_at_hotmail.com wrote in message <87v3dr$ore$1_at_nnrp1.deja.com>...
>Hi,
>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:
>
>1. The class which implements the public methods. (for simplicity of
>testing all methods do not have any parameters)
>
>2. 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.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Thu Feb 10 2000 - 00:00:00 CET