What is the equivalent of utassert eqtable / eqquery in utPLSQL v3 In utPLSQL v2 you had to use ‘quoted text to compare tables / queries. utPLSQL v3 allows you to compare table data using native refcursors without usage of dynamic SQL. In v2 with you would use syntax or syntax: In v3 you will use syntax: Additionally v3 allows you to filter columns of cursors so… Read More
Beware of raise_application_error from within exception when others Intro Most of use-cases for current Oracle databases involve some kind of application server that is managing database connection pool. The pool is keeping database connections open for long time to avoid the overhead of connect/disconnect handshakes. Taking into consideration, that deployment of database changes, is more and more often required to be done seamlessly,… Read More
UTPLSQL vs. ruby-plsql – Oracle unit testing frameworks for developers comparison Last two months I was blogging quite a lot about UTPLSQL vs ruby-plsql. There are lots of aspects that I did not manage to cover so far. I’ve had a ambitious plan to go through all of the details and dig into the darkest corners to show all the differences. Time is however one thing… Read More
UTPLSQL vs. ruby-plsql – exception handling I recently use utPLSQL in my daily work as a testing framework and I’ve noticed that the framework is doing quite bad job on exception handling on the tested code. I’ll try to demonstrate it with a simple/yet realistic scenario. Scenario Consider a CUSTOMERS table created and populated with following script We have an API… Read More
UTPLSQL vs. ruby-plsql – Running Oracle unit tests on Jenkins CI I my previous posts I have described some differences between UTPLSQL and ruby-plsql. This time I want to focus on automating the test execution with each of those frameworks using Jenkins Continuous Integration. The reasons for continuous testing Some of the problems that I often see in projects is that developers don’t fully acknowledge the… Read More