Blog¶

January 24, 2014
in testing
3 min read

How I started to create Unit Tests for Oracle PL/SQL code

Before I started working at Pragmatists I never actually took time or effort to research the web for automating the testing process in Oracle databases. My previous job was more about delivering solutions, advisory, analysis, design and implementation using the traditional cascade product delivery approach. I don't want to get into too many details on how it happened, that me, being a Oracle database developer, landed in Pragmatist, which is an Agile Software Development company specializing in Java, but all I need to say, is that nothing else but good came out of it for me.

January 22, 2014
in SQL*Plus
1 min read

SQL*Plus default values for script parameters

While working heavily on script automation I came across the issue of having an SQLPlus script with optional parameter. Oracle does not allow that by default, and one needs to use a dirty trick to make it work. Vladimir made a great article on how to achieve that. Thank you Vlad, this is really helpful. Vladimir's Diary: On SQL*Plus Defines.

January 1, 2014
in SQL*Plus
3 min read

SQLPlus ERRORLOGGING does not keep error log on rollback

Recently I'm heavily involved in SQL*Plus scripting automation tasks. I must admit that despite all the settings you may set and retrieve with SQL*Plus, it is a real pain to do some good automation with this tool. I'm very glad that Oralce continues to extend Oracle SQL*Plus features, but i must say that it seems like the design details for those new features are not well thought, which gives me a headache when working with this tool and forces me to look for tricks and workarounds for badly designed functionality. In this post I'll write about the downsides of the ERRORLOGGING feature introduced with SQL*Plus 11.1 and above.