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
UTPLSQL vs. ruby-plsql/ruby-plsql-spec – part three – (not) reporting failures I have finished my previous post with comparison of basic reporting capabilities build into UTPLSQL and ruby-plsql frameworks for Oracle unit testing. Additional reporting options for ruby-plsql So far I have been using the ruby-plsql-spec wrapper around RSpec to run unit tests, however ruby-plsql was created in a way, that developer is not limited to… Read More
UTPLSQL vs. ruby-plsql/ruby-plsql-spec – part two (setup and basic reporting) In my previous post I have described the conceptual differences between UTPLSQL and ruby-plsql frameworks for unit testing of Oracle database code. I have used a message_api package and unit tests for that API using both frameworks as an example. In this post I will focus on getting the tests to run and the feedback… Read More
UTPLSQL vs. ruby-plsql/ruby-plsql-spec – part one Foreword Unit Testing is around for quite a while. Since it started to become more and more popular, quite a few tools became available for Oracle database to allow unit testing of the database. There are the UI based tools like Quest Code Tester (now Dell Code Tester for Oracle), Oracle SQL Developer unit testing.… Read More
PL/SQL performance freak series – alternatives to PL/SQL function calls from SQL Last week I revealed the numbers standing behind the overhead of calling a Pl/SQL function from within an SQL statement. I’ve left two questions open: – Is it always a performance issue, when you call a PL/SQL function from a SQL statement? – What can be done to maintain the function encapsulation (have the code DRY) and… Read More