Hi Kevin!
>1) What is involved in connecting to an Oracle database? An exmaple would be nice.
You can to create a ODBC (or DSN-Less) and to use SPT, some functions like: SqlConnect(), SqlExec(), SqlDisconnect().
Good luck!
Erick
Força Sempre!
Strength Always!