Skip to Main Content


Dev Live Dev Intro

This month we are celebrating Developers at AskTOM. We welcome Developers of all levels of experience to join us at our FREE Developer Live events coming in August. Just click on the left to register today! If you are brand new to Database Technology, then we also have got you covered. Just click on the right for your comprehensive FREE training program to kick start your Oracle Database Development journey!

Question and Answer

Connor McDonald

Thanks for the question, Zahid.

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

Answered by: Connor McDonald - Last updated: July 30, 2020 - 8:47 am UTC

Category: PL/SQL - 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.