Hi guys and gals, just thought I'd let you know of a nice little application I found whilst trolling
for a solution to my Oracle woes.
The idea was to add secure email SMTP functionality between a standard ad-hoc Gmail account (in-fact
you must use TLS, you don't have a choice) and Oracle DB PL/SQL code directly. The primary benefit then is, you
don't need an SMTP relay or email server and you won't have network routing problems connecting
to your email box. Connectivity from anywhere, at anytime. Another benefit is you can use Oracle 11g Express Ed (free)
without the need for certificate management - which is only available with the pay $$$ editions (see Oracle wallet).
So the app that solves the problem is stunnel (
https://www.stunnel.org/docs.html).
A small footprint proxy you can implement that provides scale-able load-balancing SSL/TLS and even VPN
functionality to any server (without code modification) supporting the common internet protocols.
Works like a charm - right out of the box. I was so impressed ;) I can now email within standard PL/SQL
code directly, using any format (text,html etc.) with any type of attachment (csv,html,pdf etc.) supported.
Have a great day friends
Raistlin