OraPGP version 1.1 has been released

On the 19th of August this year we have released version 1.1 of DidiSoft OraPGP – the OpenPGP cryptography package for Oracle (c) PL/SQL.

What’s new in version 1.1?

Version 1.1 provides custom exception handling strategy in PL/SQL, which was missing in the first version of the package.

There are also overloaded versions of the ORA_PGP.ENCRYPT and ORA_PGP.DECRYPT functions accepting OpenPGP keys as variables of type BLOB. This provides the possibility keys to be loaded from external files through BFILE file handles and directories available to the Oracle (c) Database server through the CREATE DIRECTORY PL/SQL statement.

Upgrade from version 1.0

In order to upgrade from version 1.0 to the current version 1.1, first unload the old version JAR files from the Oracle© database:

dropjava.sh/.bat -r -v – u user/pass [extraction folder]\SetupFiles\jce-jdk13-151.jar
dropjava.sh/.bat -r -v – u user/pass [extraction folder]\SetupFiles\bcpg-jdk13-151.jar
dropjava.sh/.bat -r -v – u user/pass [extraction folder]\SetupFiles\pgplib-2.7.0.jar
dropjava.sh/.bat -r -v – u user/pass [extraction folder]\SetupFiles\ora-pgp-1.0.0.jar

After the old JAR files are unloaded continue to Setup.

Note: Don’t forget to replace above user/password with the database username/schema and password used in the initial Setup.