In order to find out how to do unit testing of PL/SQL code, I found this great blog post by Raimonds Simanovskis. He created two Ruby gems, ruby-plsql and ruby-plsql-spec. Following instructions on github for plsql-spec gem, I installed gems, but for jruby platform.
There are other alternatives for doing unit testing of pl/sql code (Python is one of those and I have been using Python for years), but I decided to try Jruby implementation for three reasons:
- Ruby language has better readability than Python (there, I said it). Its idioms are much comprehensible than Python language.
- Rspec gem is better than Python unittest module.
- Java jvm is better than Ruby virtual machine implementation