The More You Know

Session three turned out to be great! The subject matter was on error handling in PL/SQL and how while Oracle 10gR2 has fixed a few issues with PL/SQL error handling, there is much more that each developer can do to increase the usefulness of errors to developers and the verbosity for users. As a bonus it was given by Steven Feuerstein who has a great presentation style. I will admit I do not agree with everything he presents, but at least he does it in a way that keeps me listening.

What he did covers was usefulness of the DBMS_UTILITY package … Continue Reading

The second section I attended was title “Dynamic PL/SQL.” The presentation was done by Dr. Paul Dorsey and supported by Michael Rosenblum. The topics covered were quick and rapid. However I was able to pull out a list of interesting topics covered and even some detail. The presentation was very technical and thusly was hard to write about as being done. Also the depth taken is farther than a quick blog post will do justice for.

Firstly, the quirks of dynamic SQL that were covered were the 32k length limit of a SQL query. In 8i, you could concatenate any length … Continue Reading

The key note speaker for OPP 2007 east was Steven Feurstein from Quest Software. Being a key note speaker his job is to welcome everyone to the conference and bring an over all tone to conference. What Steven did was bring to light many topics that are both generically interesting to all programmers, no matter the language and environment, but also bring something that the PL/SQL community is lacking, modern methodologies. Ideas like extreme programming, test driven development, and agile development.

Since my induction into the world of PL/SQL, I have noticed a near complete lack of progressive programming tactics. This … Continue Reading