BUG in INSERT … SELECT with nested objects 2020-04-05 | Leave a comment I came across a very nasty bug in Oracle SQL engine while working on some new code. It took me a while to figure out what the problem is as the SQL code I was working on was acting weird. The work was related to refactoring and consolidating an existing code. As part of the… Read More
INSERT … LOG ERRORS and SQL%ROWCOUNT-continued 2020-03-17 | Leave a comment In my previous post I have described solution allowing you to obtain count of error rows that get inserted into error table when using Oracle SQL syntax of INSERT INTO … SELECT … FROM … LOG ERRORS. The solution provided had a bug related to resetting counters. You might say, that the problem was with… Read More
INSERT … LOG ERRORS and SQL%ROWCOUNT 2020-02-10 | 3 Comments Oracle SQL has a really neat feature to log the rows that failed to be processed during DML statement (INSERT / UPDATE / DELETE / MERGE ). This is really great feature and you cen read a lot more about it on oracle-base.com The thing I was wondering about is, if I log errors and… Read More
What is the equivalent of utassert eqtable / eqquery in utPLSQL v3 2017-10-30 | Leave a comment In utPLSQL v2 you had to use ‘quoted text to compare tables / queries. utPLSQL v3 allows you to compare table data using native refcursors without usage of dynamic SQL. In v2 with you would use syntax or syntax: In v3 you will use syntax: Additionally v3 allows you to filter columns of cursors so… Read More
Test Driven Development in PLSQL with utPLSQL v3 – intro 2017-10-26 | Leave a comment Foreword The biggest challenge around unit testing is to make it work for you (as an engineer), not against you. Many developers struggle, when writing unit tests. This is mainly due to the fact that while we are educated in design and implementation of database software, we are not mentored on unit testing. The struggle leads… Read More