This website uses cookies to store information on your computer. Some of these cookies are used for visitor analysis, others are essential to making our site function properly and improve the user experience. By using this site, you consent to the placement of these cookies. Click Accept to consent and dismiss this message or Deny to leave this website. Read our Privacy Statement for more.
But that worked yesterday

 

…or why you should test with utPLSQL

 


Here we take a detailed look at how to get started




 

The lament in the headline might be very familiar to most developers and even more painfully to quite a few users. “What happened between yesterday and today to cause my application to break? And why did it have to be reported by my user?” After some contemplation, we remember a small change we made yesterday, shortly before leaving for home.

This article shows how easy it is to start developing self-tests in Oracle with utPLSQL version 3 (https://utplsql.org). Automated self-tests are a fundamental part of application and web development nowadays, to the point where it’s hard to imagine modern software development without them. Yet they are still surprisingly uncommon in the database. We also take a look at the many benefits these tests can bring to your project and your software.