OraRSA tutorial

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

• Encrypting
• Decrypting
• Creating digital signatures
• Verifying digital signatures

X.509 certificates

• X.509 certificate properties

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

• XML Signatures
• SOAP WS-Security

CMS (Cryptography message syntax)

• CMS encrypting
• CMS decrypting
• CMS signing
• CMS signаture verification

JWT (JSON Web token)

• JWT encoding, decoding, and using with APEX_WEB_SERVICE

Exception handling

Appendix A. Exception handling