The More You Know

The last session of the day included a first look at Quest Software’s PL/SQL Code Tester which brings something very new and exciting to the world of Oracle development, easy and intuitive regression testing! Very much like JUnit for Java, Code Tester brings a great UI to the user and offers the ability to quickly create test cases.

Of course the skeptics at this point will start spinning their worst PL/SQL function calls in their heads. Attempting to think of the impossibilities of such a task. Be assured cursor variables, collections, and even hierarchal data have all been considered. Granted, the … Continue Reading

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