Logger 2.1.0 - 10g Sequence Fixed

In preparation for the release of Logger 2.1.0 I’ve decided to write a few posts highlighting some of the new features.

Apparently not too many people who use Logger are still running Oracle 11gR1 or lower since I was only notified of this issue now. Patrick Jolliffe was kind enough to point out that there was an issue when installing Logger in a 10g. It turns out that :new.id := logger_logs_seq.nextval; doesn’t work in 10g. It only works in 11gR2 and above. Clearly it’s been a while since I’ve used 10g, or better yet 11gR1.

The ability to reference sequences nextval in PL/SQL is mentioned in the 11gR2 New Features guide.

Logger 2.1.0 address this issue by only supporting the old select into... technique for various reasons. At first I was skeptical about performance impacts of having the context switch, however it appears that behind the scenes if called from PL/SQL it does an internal select into to obtain the value. Connor McDonald has some good slides about this here (see page 59 onwards).

Thanks to Dan McGhan and Scott Wesley for helping sort this issue out.