Monday, July 8, 2019

My Kscope19

A little later than many post-Kscope19 blog posts (because the wife and I just had a nice relaxing vacation week right after I returned from Kscope ;-), but better late than never. A few thoughts, but for once not a lot of writing - most of this post is a video...

Tuesday, June 18, 2019

Coming up: My 10th Kscope!

In June 2010 I attended ODTUG Kaleidoscope 2010 in Washington D.C. I got this T-shirt:


But I didn't get just a T-shirt, I got an awesome experience. And most importantly I got to be part of a fabulous community of friends all over the globe without whom I wouldn't be where I am today.

Being hooked from day one, I've been to each and every Kscope since - attending, speaking, ambassadoring, volunteering at all community service days, having fun, helping others, getting help, and so on. In short: getting my yearly inoculation against LowTech Syndrome.

It's also taken me around the US:

Kscope10Washington D.C
Kscope11Long Beach, California
Kscope12San Antonio, Texas
Kscope13New Orleans, Louisiana
Kscope14Seattle, Washington
Kscope15Hollywood, Florida
Kscope16Chicago, Illinois
Kscope17San Antonio, Texas
Kscope18Orlando, Florida
Kscope19Seattle, Washington

And now I am just *so* ready to go to Seattle for Kscope19 (my 10th anniversary Kscope), where I've got a packed schedule:


Add to that:

  • Attending 8(ish) other presentations and learn something (still trying to decide which.)
  • Mingle and chat at Breakfast, Lunch, Coffee/Tea Breaks, Happy Hours, etc.
  • Visiting Exhibit Hall and see what's new.
  • Meet as many old and new friends as possible.

When flying back home, I'll be bushed, but believe you me - it's worth it!

I'm not alone in thinking Kscope is a great conference. I do have a couple of colleagues from Trivadis also speaking:


Philipp Salvisberg will be speaking about:

Dani Schnider will be speaking about:


We're all looking forward to seeing you all in Seattle for ODTUG Kscope19.

Monday, March 11, 2019

Results of the Dev Gym SQL Championship for 2018

All the after-play checking of the results of Oracle SQL Annual Championship for 2018 is done. The awards have now been processed, and it is with great pleasure I can publish the results here to serve as an inspiration for you to trying out your own SQL knowledge at the Dev Gym.


Monday, January 14, 2019

ORA-22905 when calling ODCI Table functions from PL/SQL

Back in 2015 I experimented using ODCITable* functions to dynamically parse delimited text (see blog post here.)

Now blog reader Daniel Cabanillas points out, that it raises an error when used in PL/SQL. Silly me - I had only tried it out in SQL (my favorite language) and had completely missed that it failed in PL/SQL.

Lucky for me, the classic workaround of dynamic SQL works here too 😁

Participant list for Oracle Dev Gym SQL Championship 2018

2018 is over. Throughout the year people have participated in the "Select for SQL" Tournament on Oracle Dev Gym. It's time for the Top 50 to try their skills in the Annual SQL Championship!


Everybody who tried the quizzes have hopefully had fun as well as exercised SQL skills. Maybe even learned a little :-) I hope you'll all keep working your mental muscles in 2019 as well - get your friends and colleagues to try it too! I'll do my very best to try and pass on knowledge via the quizzes.

Whether you worked out with the quizzes for fun alone or you played in the tournament as well, thank you for being there in 2018. And congratulations to the Top 50 in the "Select for SQL" Tournament on Oracle Dev Gym in 2018 for the stamina and skill displayed to be ranked sufficiently high at the end of the year to participate in the Championship.

Thursday, October 11, 2018

ODC Appreciation Day : The ever growing toolbox

It's ODC Appreciation Day 😃 !

The day initiated by Tim Hall where Oracle bloggers worldwide make a blog post to show appreciation of the Oracle Developer Community.

This year I won't dive into a specific technical thing in SQL or PL/SQL, but rather I'm appreciating how much my toolbox grows all the time with new bits coming in a steady flow.


Tuesday, May 1, 2018

Corrupting characters - How to get invalid byte values stored in strings

Having worked with Database Migration Assistant for Unicode (DMU) to convert some databases from single-byte charactersets to AL32UTF8, I had problems with DMU reporting a lot of characters with invalid byte values (in this case binary values that did not exist in WE8ISO8859P15.)

So how can that happen? Doesn't the database enforce character encoding to match the database characterset?

Wrong - not always.

Well ok, you can get invalid values with single-byte charactersets - but once the database is AL32UTF8 then it can store all the characters in the world, so then it cannot happen, right?

Wrong again - you can still get corrupt character data if you do it the wrong way.