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/ruby-plsql-spec – implicit datatype conversion traps … continued I’ve finished my previous post a bit too soon and was not precise on the ruby-plsql unite test results analysis. I’ve decided to dig a bit deeper to validate that ruby-plsql (RSpec) actually support datatype mismatch exceptions where utPLSQL unit testing fails due to oracle implicit datatype conversion. Retrospective Lets have a look once more… Read More
UTPLSQL vs. ruby-plsql/ruby-plsql-spec – implicit datatype conversion traps This post is a continuation of the utPLSQL vs. ruby-plsql series, you might want to have a look at my previous post for introduction and some basics. Foreword Recently I’ve spent quite a lot of time investigating utPLSQL and ruby-plsql. Working on my previous articles made me think about very foundations of PL/SQL language. Sadly,… Read More
ruby-plsql cheatsheet In my previous posts I did some writngs on UTPLSQL and ruby-plsql. For long time, while developing Oracle code I was using ruby-plsql to do test driven development for SQL and PL/SQL. I used to frequently forget how to use some of the functionalities of ruby-plsql, specially after having a longer break and so each… Read More