Presenting at OGh APEX World 2015

On March 25th 2015 at the beautiful venue of the former cruise ship SS Rotterdam, the next edition of APEX World by the Dutch Oracle Users Group (OGh) will take place.

SS Rotterdam

There is a long list of very interesting speakers there. David Peake, Steven Feuerstein, Joel Kallman, Dimitri Gielis, John Scott and Peter Raganitsch, just to name a few, have been selected to deliver presentations and keynotes at this event. And I’m proud to say that my name is also on that list.

I’m planning to do a presentation based on the following abstract:

APEX and SOA – The best of two worlds
Many companies have invested in an APEX application or a Service Oriented Architecture. But why not use both? In this presentation we will see the possibilities offered by APEX and the Oracle SOA Suite to communicate and integrate with eachother.

I hope to see a lot of familiar faces there and also a lot of new faces that want to learn more about this subject.

If you would like to attend, more information can be found on the OGh website. There are still some seats left, but they are going fast!

Christmas Giveaway and Packt $5 eBook Bonanza

Packt’s $5 eBonanza returns

Following the success of last year’s festive offer, Packt Publishing will be celebrating the Holiday
season with an even bigger $5 offer.

From Thursday 18th December, every eBook and video will be available on the publisher’s website for
just $5. Customers are invited to purchase as many as they like before the offer ends on Tuesday
January 6th, making it the perfect opportunity to try something new or to take your skills to the next
level as 2015 begins.

With all $5 products available in a range of formats and DRM-free, customers will find great value
content delivered exactly how they want it across Packt’s website this Xmas and New Year.

Find out more at www.packtpub.com/packt5dollar

5-dollar-promo

Adding to the fun, Packt has given me the opportunity to give away 3 free copies of my APEX Cookbook, Second Edition (the eBook).
To win, simply comment on this post or use the contact form with your nicest new year wishes before the end of December 31st 2014 (Dutch time) and I will randomly select 3 winners.

Winners will be contacted by Packt to arrange details for receiving their prize.

Oracle SOA Suite 11g Certified Implementation Specialist

Last week I took the Oracle SOA Suite 11g Certified Implementation Specialist exam (1Z0-478) and passed.

Oracle Certified Specialist

Oracle Certified Specialist

I can now officially wear the badge of Oracle Certified Specialist.
So in the future you will also see some SOA related posts on this blog next to the APEX content.

Oracle Certified Specialist

Oracle Certified Specialist

APEX Cookbook Giveaway Contest!

My publisher Packt has given me the opportunity to start a contest. 3 lucky winners will receive a copy of my book for free!

Book Give-away:
Hold a chance to win free copy of the Oracle APEX Cookbook 2nd Edition, just by commenting!
For the contest we have 3 copies of Oracle APEX Cookbook 2nd Edition, to be given away to 3 lucky winners.

How you can win:

To win your copy of this book, all you need to do is come up with a comment below highlighting the reason “why you would like to win this book”.

Duration of the contest & selection of winners:

The contest is valid for a week from 12th to 19th of March, and is open to everyone. Winners will be selected on the basis of their comment posted.

About the book:

Oracle APEX Cookbook Second Edition

Oracle APEX Cookbook Second Edition

Oracle APEX Cookbook : Second Edition gives clear steps to create web applications, while explaining you the concepts and bringing out useful tips and techniques to make learning interesting for you. In this second edition, readers can learn how to modify themes and templates and how to use the new HTML5 and CSS3 features. Book also explains how to create visual effects such as tool tips and fading options. Furthermore, topics such as web services, publishing, administration, team development, and web sheets will be covered. After reading this book, readers can create feature-rich web applications in Application Express 4.2 with ease and confidence.

This book is aimed both at developers new to the APEX environment and at intermediate developers. More advanced developers will also gain from the information at hand. Readers new to APEX will find recipes to start development and an experienced user will find ways to improve productivity and efficiency and make the most of APEX to enhance their applications.

Oracle APEX Cookbook Second Edition

Oracle APEX Cookbook Second Edition
Oracle APEX Cookbook Second Edition

Oracle APEX Cookbook Second Edition

After months of hard work, Marcel van der Plas and I have finally finished the Second Edition of our Oracle APEX Cookbook.
Two new chapters and many new recipes describe how to build even better APEX applications.
The first new chapter is on HTML5 and CSS3 and explains how to use new item types, templates and much more.
The other new chapter explains how to build applications for Mobile devices like Smartphones.

To ensure the quality of the book, many well-known names from the Application Express community have helped to review the book. People like Dimitri Gielis, Maarten van Luijtelaar and Surachart Opun reviewed the first edition. To this line-up the names of Learco Brizzi, Iloon Ellen-Wolff, Ronald Rood, Tony Jedlinski and Benjamin Kweku Intsiful have been added.

The book can be purchased on the website of Packt Publishing and many other webstores.

The author and his book

The author and his book

Substitution Variables over a Database Link in APEX

Situation: APEX 3.1.2 on a 9.2.0.6.0 database linking to Siebel.

When I was building a report on 2 tables, one local and one remote, I noticed a very big performance issue. I thought I had solved this by adding a DRIVING_SITE hint, but this wasn’t enough.

The query looked something like this:

select /*+ DRIVING_SITE(e) */
e.ename
, d.dname
from emp e
, dept@remote d
where d.id = e.dept_id
and d.loc = :P2_DEPT_LOC

In the page, a user can select a Department Location and press a button. The report data is then generated based on this selected location.

To debug this, I started investigating trace files on the remote database. What I immediately noticed was, that the Substitution Variable :P2_DEPT_LOC wasn’t replaced by it’s value that was selected in the APEX page. So that was the problem.

To solve this, I simply had to replace the way the Substitution Variable was called. The query was changed to:


select /*+ DRIVING_SITE(e) */
e.ename
, d.dname
from emp e
, dept@remote d
where d.id = e.dept_id
and d.loc = '&P2_DEPT_LOC.'

And everything was okay. The time it took to load the page changed from 45 minutes to 0.05 seconds.

But be aware! This kind of solutions opens the door for SQL Injection, so make sure that you handle the input before parsing the query.

Passed APEX 3.2 Beta Certification

Oracle Application Express Developer Certified Expert Logo

Yesterday I returned from my summer vacation in the French town of Pierrefite-sur-Sauldre. Me and my family spend 2 wonderful weeks in the Alicourts resort.

This morning I opened my e-mail for the first time and found a nice little surprise from the Oracle Certification Program.
A while ago (in february) I participated in the Application Express 3.2 certification beta program. I took the exam in Utrecht and waited for the beta period to end.
The e-mail I received from Oracle and Pearson VUE contained a link to my Score Report. The verdict was: Passed!

So now I’m officially certified in “1Z1-450: Oracle Application Express 3.2: Developing Web Applications” or Oracle Application Express Developer Certified Expert for “short” :)

TNS_ADMIN for multiple Oracle Homes

Last week I tried to install Oracle Forms 11g. This install created a new Oracle_Home on my computer, which resulted in my database not starting up anymore.
The cause of this was, that my computer did not pick up the right tnsnames.ora file anymore, but instead it picked up the new tnsnames.ora that was created during my Forms installation.

To avoid having to have multiple copies of the same tnsnames.ora file on your computer, you can create a registry key in all Oracle_Homes. This will force your computer to pick up the same file for all your Oracle_Homes and thus allow you to have just a single copy of tnsnames.ora to manage.

To do this, start the Windows Registry editor by using Start -> Run -> Regedit and find your Oracle_Homes under HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE and rightclick on your Oracle_Home entry. Choose New -> String Value and enter the required information similar to the following screenshot (directory on harddrive may differ on your computer).

TNS_ADMIN registry entry

The registry key is called TNS_ADMIN and it’s value is the location of your tnsnames.ora file on the harddrive.
But remember to only add this key to the Oracle_Homes that do not contain your central tnsnames.ora.

APEX 4.0 New Features

I did another Whitebook (in dutch). This time the subject is New Features in the APEX 4.0 Early Adopters release.
You can find it at the Whitehorses website.

By the way; besides this personal blog I also publish articles on the blog at the Whitehorses site together with the other Oracle, Java and SOA specialists of the company. These blogs are in english. A direct link to the list of my blogs is in my profile.