Posts Tagged ‘PL/SQL’

PL/SQL String Tokenizer

3rd May 2009 by jt 1 Comment

One of my goals for Log4Ora is to make it easy to use.   Has the ability for you to set the module name for logging.  This is handy in the logging so you can see where in the code the log message came from.  Downside of the Log4PLSQL implementation is you have to set the [...]

Launching Log4Ora

29th April 2009 by jt 1 Comment

Today, I’ve started my own little open source project called Log4Ora.
I’ve found logging in PL/SQL is a weak area.   I have not found a solution for PL/SQL with the versitily of a mature logging product such as log4j.
What I see most often, are home grown solutions, where the author creates a simple API to write [...]

Developing Oracle Developers

19th April 2009 by jt 1 Comment

My friend Chet recently posted about a co-worker of his that was not convinced about the effectiveness of PL/SQL APIs.  I responded to his original post saying his coworker was clearly ignorant of best practices in software development, and I pointed out that providing an API to update a table, is fundamentally using encapsulation.    Chet [...]

CI Builds with PL/SQL

21st March 2009 by jt 3 Comments

Getting started with CI Builds for PL/SQL