This online tutorial demonstrates the usage of the DidiSoft OraRSA (ORA_RSA, ORA_SMIME, ORA_XML) PL/SQL package.
Intended audience: PL/SQL developers, Oracle DBA’s
Introduction
ORA_RSA is a PL/SQL package for performing RSA asymmetric cryptography, CMS (Cryptography Message Syntax) and JWT (JSON web token) operations. The package supports RSA keys in a wide variety of common formats, including .cer/.crt, PEM and DER-encoded keys, .pfx/.p12 (PKCS12) password protected formats.
ORA_SMIME extends UTL_SMTP with support for S/MIME (Secure/Multipurpose Internet Mail Extensions) signed end encrypted emails.
ORA_XML offers XML digital signatures and SOAP WS-Security functions.
Table of contents
Setup (ORA_RSA, ORA_SMIME, ORA_XML)
Upgrade
Uninstall
From trial to production
ORA_RSA – low level RSA cryptography
X.509 certificates
ORA_SMIME – S/MIME signed and encrypted emails
- Sending Emails from PL/SQL
- S/MIME signed email with UTL_SMTP
- S/MIME encrypted email with UTL_SMTP
- Decrypting S/MIME
ORA_XML – XML and SOAP based cryptography
CMS (Cryptography message syntax)
JWT (JSON Web token)
Exception handling
Appendix A. Exception handling