Skip to Main Content


Question and Answer

Connor McDonald

Thanks for the question, Zahid.

Asked: July 29, 2020 - 2:37 pm UTC

Last updated: July 30, 2020 - 8:47 am UTC

Version: 11.2

Viewed 100+ times

You Asked


I don't know this is the right place or not but need to complete this task using PL/SQL. Actually I need to write PLSQL Code need to create a file and encrypt the file using PGP public key. I don't know how to achieve the second part of this task (file encryption) can I use dbms_crypto package for file encrypt and decrypt or need to some other rout. Our client already provides the PGP public key we don't need to create a PGP key need to use that key and encrypt/decrypt the file.

Hope I clear enough my requirement.


and we said...

We don't natively have an implementation of PGP encryption.

There is a 3rd party solution orapgp, but I can't give you any feedback on it because I've not used it.

Others welcome to add their experiences.

Is this answer out of date? If it is, please let us know via a Comment