Sorry ...

Apparently my procedure for sending mails is not working like it should.

Yesterday I updated DG Tournament with the Euro 2008 fixtures. Today I used a screen in my admin module to send out a mail to announce it to the people who played with the World Cup 2006 app. The initial program, created in 2006, supported one tournament. At the end of 2006 it got rewritten to support multiple tournaments.

Apparently I missed in my mail procedure a parameter to only send mails for the current tournament (more technically in the WHERE clause).

I want to deeply apologize for the "spam" some of you may have had.

I will never forget a quote of Tom Kyte: "It ain't so much the things we don't know that gets us in trouble. It's the things you know, that just ain't so or just ain't so anymore or just ain't always so."

I thought my procedure of 2006 would still work ;-)

Have fun with Euro 2008 and bet

If you're a football enthusiast like me, June 7 will be marked in your agenda!
The start of the EURO 2008 tournament is coming closer. My country (Belgium) is not making part of the participating teams. I find it also a pity that England won't be there as I'm a huge fan of David Beckham. Some people don't like him, but have a look at this video from this weekend!



Although my favorite teams won't play, Euro 2008 will still be worth to follow! One of the matches I really look forward to is the Netherlands against Italy.

Do you remember the World Cup 2006? At that time I created an APEX application to keep track of the scores. It got extended so you could also bet on the games and that was so much more fun. Some people asked me to do it again in for Euro 2008, so here we are. A few weeks before the start of the tournament, I'm happy to say DG Tournament is open for you to play again!


I think it's an excellent chance to bet with your colleagues, family, friends or enemies ;-) You can bet on the games for free, it's just for fun. As this application was also created to promote Oracle Application Express, we give the person who wins the bet a free ticket for our European Apex Training Days in September in the Netherlands. But as the application is also open for others we also give you the choice for an iPod Shuffle.

If there are other people or companies wanting to sponsor, feel free to write me a mail or add a comment on this post. The initial goal is to have a lot of fun again, but if we can win something it's always nice too.

Good luck!

Local APEX patched successfully

This morning I patched my local Application Express installations to 3.1.1.

I went to Metalink to download the patch. The full APEX 3.1.1 installation is also available now.

Unzip the file and read the Patch notes. Basically I had to login as SYS on my 11g database and run apxpatch.sql. After 4:36 minutes my APEX 3.1 was patched to 3.1.1. The only thing left to do was to copy the images directory. This is different if you run Apache or the Embedded PLSQL Gateway. A few seconds later I was done.

Starting my listener and going to APEX in my browser and seeing it worked ;-)

Nice if everything is going so smoothly! Thanks APEX-team.

APEX 3.1.1 Patch set released

Joel Kallman just blogged that the Oracle Application Express 3.1.1 patch is released on Metalink.

As it's already night in Belgium, I'll have a look at it tomorrow. The full version will hopefully be available by then too.

There are no new features, just bug fixes. Time to update our servers ;-)

A lot of APEX at ODTUG and Sneak Preview

It's not that long anymore before Kaleidoscope is starting.

It looks like Oracle Application Express (APEX) is getting a lot of attention! Rumors are we might see some nice new things...

On Sunday there is a full day Case Studies, titled: "The Seasoning of Application Express – Must Hear Success Stories". Together with one of our clients we present "Oracle Application Express: Power to the People ", a non-technical presentation, but it will show how people adopt APEX in one of the biggest biotechnology company.

From Monday till Wednesday there are a lot (18!) APEX sessions:

• Building the New Stuff: AJAX , JSON, and APEX 3.1 by Carl Backstrom
• Advanced Oracle Application Express Tips and Techniques by Chris Ostrowski
  
• APEX Cheat Sheet 3 by Karen Cannell
• Creating Advanced Charts in Oracle Application Express by Dimitri Gielis
  
• APEX Development: Watch It Live by Bill Holtzman
• Creating Dynamite Applications with Application Express that Deliver by Kathy Hunsicker
• Explore and Benefit the APEX Repository by Michiel Jonkers
• Go Global with Oracle Application Express by Joel Kallman
• Writing a Custom Authentication Scheme for Application Express: A Case Study by Raj Mattamal
• Migrating from Access to Oracle Application Express by Josh Millinger
• How to Hack an Oracle Application Express Application by Anton Nielsen
• Oracle Application Express (APEX) Version 3.1 by David Peake
• Application Express in Support of Institutional Strategic Planning by Tanya Podchiyska
• APEX Hints, Tips and Best Practices by John Scott
• You Can't Do THAT in a Browser! Extending Oracle APEX with Third Party Components by Scott Spendolini
• Use the Power of APEX Dictionary Views to Increase the Quality of Your APEX Applications by Karen Van Hellemont and Jan Huyzentruyt
• Increase Your Oracle APEX Development Productivity with Open Source Tools by Patrick Wolf
• Building Advanced Tabular Forms by Marcie Young

On Thursday I'm also on stage for the APEX vs. ADF Shootout.
Together with my friend, Lucas Jellema, we'll try to show you both environments and talk when to use what. When we did this talk in the Netherlands in December it was really fun. The public at ODTUG will be very different, so I'm curious to see how it will go.
But some people warned me! I got told I will be in the ring with an opponent that is heavily prepared and is getting help from some smart people. Like in boxing, I guess in the ring friends don't count anymore... I see it as I don't have anything to lose. Everybody expect the ADF monster will eat APEX, right? I hope they will show mercy with such a tiny boy ;-)

As a lot of European people might not have the opportunity to fly to the States, my friends at AMIS are organizing an ODTUG Sneak Preview. This event is completely free, but you'll have to register for it. Some of the presentations that will be at ODTUG, will be hold on the event. As you can see in the agenda, I'm also doing one of my presentations.

Some people asked when I would be in the Netherlands, so you might catch me there. Or you can come to our European APEX Training Days in Utrecht in September.

European APEX Training Days in the Netherlands

It's starting to become a tradition... After our successful Oracle Application Express training days in Brussels (September 2007) and London (March 2008) it's time to announce our third European APEX Training Days. This time it will be held in Utrecht, the Netherlands.

The environment will be a bit different. We didn't go for the Plaza hotel, instead we went for a green "theme". The setting and architecture of the Mitland hotel make you feel as if you’re in the middle of the countryside! Nevertheless, it's only 5 minutes from the city of Utrecht.

Below you find the agenda. Depending feedback we might change some topics, but these are the topics we believe will bring you to the "next" level APEX developer.


You find more information about the training days at the website of Apex Evangelists.

Hope to see you there.

Vote for APEX, somebody gets worried

OracleNerd, aka Chet Justice, wrote a blogpost that his poll about "Have you used Oracle Application Express" doesn't have that many votes for APEX.

I believe he's getting a bit worried, so I decided to call the tight APEX community to vote for APEX on his survey.

Maybe the APEX users don't read his blog or the people who voted just didn't know about APEX... Even without the big Oracle marketing machine, I can't believe that APEX is still not that known. Application Express is getting more and more adopted, especially with Oracle 11g it's taking off. So, I don't worry that much, otherwise I wouldn't have founded a company only doing APEX ;-)

Lets give OracleNerd a warm APEX vote, so he also feels a bit better!

Sometimes you love you chose Oracle

The last days it's really hot in Belgium. Working when it's hot is not good for our brains and the computers as they get overheated.

Some people are distracted as they think about the pool all the time, some others get grumphy and some others make mistakes...

In the last couple of days I had to use the flashback feature of the Oracle database more than the last 6 months together. When you get a mail like: "I had to change something, but accidentally deleted the whole text. Can you please put it back?"

At that time you're so glad you use an Oracle database! Can you do something like this in MySQL or MS SQL Server?

SELECT *
FROM my_table AS OF TIMESTAMP TO_TIMESTAMP('2008-05-12 08:00:00', 'YYYY-MM-DD HH24:MI:SS');

Another command I had to use for myself, when I dropped a table in development, but forget to look at the logic of an existing trigger of that dropped table:

FLASHBACK TABLE my_table TO BEFORE DROP;

I guess everybody already knew about flashback in Oracle (if not, Tim Hall wrote a nice compact page about flashback), but then I wonder sometimes why people ask me if APEX also runs with other databases... Oracle has to many nice features buildin, so some want to use another database I guess ;-)

I'm happy the sun is shining and I'm using an Oracle database during these days.

ApexBlogs.info updated

I updated apexblogs.info with a Blog Roll on the right side, so next to clicking on the arrow after Blog Selection, which would slide down and show you the aggregated blogs too, you have a link to all APEX blogs.

I also added support for Windows Live blogs. So if you've a blog like Jason Aughenbaugh, you can get aggregated too.

If you're also blogging about Oracle Application Express (APEX), but don't find yourself in the list, please put a comment on this entry and I'll add you.

If you don't have a blog yourself, but want to do a blog post with somebody or just share your ideas, that's also possible. Login to the site (if you don't have a login, create one for free) and go to Your Posts. In there you can write your blog post and it will be shown in the aggregated blogs screen.