Oracle

Hi Aino…

I have been playing the PL/SQL Challenge quiz every day. It’s a great way to brush up on my PL/SQL skills. After many years of using PL/SQL, I am still learning about features that I have never known before or totally forgotten about. Take for example one of last week’s quiz questions: What is the [...]

I’ve been absent for a while, not sure if this tweet from Chet was related to my silence, but if it was, I have an excuse. Paul and I just returned from Austin and SXSWi, which ran March 12-16. For those unfamiliar, SXSW is comprised of three festivals: film, music and interactive. It began in [...]

Foursquare Also titled: “What I learned from FourSquare.” A few years back when we started exploring new technology, one of the ideas that seemed to stick with me was around gaming.   The processes that made something enjoyable seemed to be an essential, yet elusive ingredient in business software. In truth, I felt there was something [...]

I came to a revelation of sorts earlier in the week. Email apps, not web apps, represent New Web for the enterprise. I suppose you could say Enterprise 2.0, but if you’ve been with me for a while, you know I steer clear of that term. Photo by piccadillywilson from Flickr used under Creative Commons [...]

Various scenarios may require sending email messages or other types of notifications to users as part of the process flow. For example, certain types of exceptions that cannot be handled automatically may require manual intervention. For example, a BPEL process can use the notification service to alert users by voice, IM, SMS, or email.  In [...]

Instrumentation Cary Millsap has recently pointed to a couple of postings and quoted some people on the fine art of instrumentation.  He quoted me (and got it pretty much 100% – dead on) a couple of times as well.  I’ll add a quote/story to his list of quotes… When Oracle 10g first was released – [...]

This story started out with a user telling us that Berkeley DB Java Edition’s group commit feature didn’t work very well on ext3. The reason is that we only group fsync’s and not writes & fsyncs. And ext3 takes an exclusive mutex on the inode for any IO operation, whereas Windows and Solaris don’t (i.e. [...]

Continue PL/SQL execution beyond exceptions. Link to the original site

Every PL/SQL developer knows, or at least should know, that WHEN OTHERS THEN NULL is a hidden bug; Ask Tom. But, what about WHEN OTHERS THEN RAISE? I have known PL/SQL developers who follow a “standard” of adding: EXCEPTION WHEN OTHERS THEN RAISE; END; to every PL/SQL block. The reasoning behind this practice, as explained [...]