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

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

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

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