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 (Cipher, 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
it will also complie and run using the oracle jbk but outside the
database but once I have loaded the method into the database 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