PL/SQL performance freak series – function calls from SQL overhead 2014-05-25 | 5 Comments In my previous post I’ve shown and measured the performance loss on passing the parameters to and from procedure/function call inside PL/SQL code. In this article I’m about to reveal another bottleneck that is often forgotten and not so easy to overcome. Suppose you need to have some value calculated. The formula is straight matematical calculation but the… Read More
PL/SQL performance freak series – function/procedure parameters overhead 2014-05-18 | 2 Comments When writing a PL/SQL code, I usually use following strategy: If the code that I’m calling is returning a calculated value, it should be a function. If the code that I’m calling is doing some DB operations and is not returning a value, it should be a procedure. There are however some situations, when I tend to… Read More
SQLPlus ERRORLOGGING issues with error log on rollback resolved 2014-01-30 | 1 Comment Today I came up with idea to overcome the issue: SQLPlus ERRORLOGGING does not keep error log on rollback. The resolution is to use autonomous transactions to log the errors reported by SQL Plus. What we need to do is to somehow catch the error that is about to be logged and wrap it in an… Read More
How I started to create Unit Tests for Oracle PL/SQL code 2014-01-24 | 2 Comments 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… Read More
SQL*Plus default values for script parameters 2014-01-22 | Leave a comment 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.… Read More