Hi all,
I am trying to write a stored procedure in pl/sql to encrypt some fields in my database(Oracle 9i). I am using a
java method wrapped in pl/sql to do the encryption/decryption. The problem is that I cannot access the javax.crypto classes (secretkeyfactory etc). I have included all the JCE jar files in the {java.home}/lib/ext/ directory and I have updated the java.security file to use security.provider.3=com.sun.crypto.provider.SunJCE. My java method compiles and works fine outside oracle (using the websphere JDK) and also compiles and runs when using the Oracle JDK outside the database but once I have loaded the method into the database (loadjava) it will not compile using the internal oracle JDK. There must be some configuration that I have overlooked. I have also included the java home directory path in my classpath. Any help would be greatly appreciated. Thanks