Skip to Main Content

Breadcrumb

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 1000+ times

You Asked

Hi,

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.

Thanks,
Zahid

and Connor 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

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library