Hi just read Joel Kallman's post that the Oracle Application Express (APEX) team released 4.0.1 which corrects a number of issues found in APEX 4.0.
I recommend going to 4.0.1 if you have 4.0 installed as soon as possible.
If you still have 3.x running and want to upgrade to 4.0 you can directly download the 4.0.1 release and install that.
The new version of APEX is 4.0.1.00.03.
Wednesday, August 18, 2010
APEX 4.0.1 Patch released
Posted by
Dimitri Gielis
at
18:28
3
comments
Labels: apex 4.0
Monday, August 09, 2010
Add Default to Tabular Form in APEX
If you want to set a default value for a column in your tabular form, you can set the Default Type to "PL/SQL Expression or Function" and put into Default e.g. 'N'.
That sets the default for that column to the static text 'N'.
Posted by
Dimitri Gielis
at
15:58
12
comments
Wednesday, August 04, 2010
Upgrade to APEX 4.0 - Known Issues - Workarounds and Patches
If you upgrade your application from APEX 3.x to 4.0 you might encounter some issues.
At ODTUG I did a live migration of an application written in APEX 3.2 to 4.0 and I talked about some of the issues I discovered and how I worked around them. I'm doing the same presentation at APEXPosed in Brussels in October. You also might have seen my previous posts where I upgrade DG Tournament from APEX 3 to 4.
On the Known Issues page you see the issues categorized nicely. If the issues can be fixed by working around it, it's also mentioned there. Oracle is working hard on a patchset (4.0.1) and they hope to release it soon. On Metalink you can already find patches for specific issues too.
I plan to write some other blog posts with steps I did when upgrading DG Tournament to APEX 4.0.
Posted by
Dimitri Gielis
at
15:21
12
comments
APEX Father is speaking ...
If you didn't pickup another important APEX blog to follow yet... you definitely want to follow Mike Hichwa.
Mike is the "father" of APEX, it must be over 10 years ago he started with the development of APEX (HTMLDB/Project Flows).
Mike is a VP at Oracle and is now responsible for a lot more than APEX alone. He also has SQL Developer and many other tools all related to Database Development.
Posted by
Dimitri Gielis
at
14:54
0
comments
Labels: apex
Tuesday, August 03, 2010
ODTUG comes to Europe in October! Registration open!
As announced on the latest OBUG APEX SIG, we will participate in the first ever ODTUG event in Europe!
It's a two day conference focused on PL/SQL and APEX, with two full tracks for each.
If you look at the Agenda you will see the presenters are well known in the APEX community and amongst the best in their field. On the PL/SQL side you have ofcourse Steven Feuerstein and a lot of other big names.
Registration is open now, so don't wait to register, places are limited!
Posted by
Dimitri Gielis
at
16:00
0
comments
Thursday, July 15, 2010
My first time at Orcan - and wearing a kimono!
A few months ago I got an invitation from the Swedish Oracle User Group (Orcan) to present at their event, which I agreed to do. It was my first time in Sweden and it was an unbelievable experience. The environment is so nice there... a lot of green (trees), a lot of water, nice people...
About the event itself, it started all normal. My first presentation was "Mastering an APEX Page", which you might have seen me doing before. I basically explained how an APEX page works and how/where to change things so you get exactly what you want.
The event was also a great time to meet other people I didn't meet before but follow on internet. On the picture you might recognize Francisco Munoz Alvarez, Daniel Morgan, Husnu Sensoy, Grant Ronald and Jose Senegacnik. We all had a great time with some nice food.

If you've never been to Sweden or one of the events of Orcan, it's definitely worth it.
Thanks to Patrik Norlander and his team to make this an unbelievable experience.
Posted by
Dimitri Gielis
at
17:03
4
comments
Labels: orcan, swedish oracle user group
DG Tournament / World Cup 2010 wrap-up
The World Cup 2010 is over... Spain is victory, the Netherlands lost in extra time, but can be proud on the tournament they played. And I was surprised how well Germany played.
Over 400 people had fun on DG Tournament by betting on the games and chatting with others.
Congratulations to the top 5!
The people interesting in some stats; there's a stats page in the app itself and below I put a screenshot of the page loads during the time of the World Cup. Over 120,000 page loads... not bad at all.
See you again in the next tournament... hopefully Belgium qualifies next time!
Posted by
Dimitri Gielis
at
09:21
0
comments
OBUG APEX SIG - APEX 4.0 day - the month after
On Thursday June 17 the first OBUG (Oracle BeNeLux) APEX SIG 4.0 day took place in congress centre 't Elzenveld in Antwerp. Over 90 visitors, great sessions and a beautiful day, made it a very successful event.
After I welcomed the people and talked a bit about the purpose of the OBUG APEX SIG, we kicked off with the first presentation (keynote) of the day. Patrick Wolf talked about Oracle APEX 4.0 - The next step in Web Application Development. He gave an overview of the new features in APEX 4.0 and talked about how things change for a developer.
Next Patrick Hellemans of InterAccess came on stage to talk about the Maturity level of APEX. He talked about developing in Agile, how to handle projects and by having a framework be able to go even faster.
After lunch Roel Hartman presented "Creating sub-zero Dashboard plugin for APEX with Google Visualizations". He showed how you can create a more advanced APEX Plugin (based on Google Visualizations). His demos were very cool! Roel already blogged about the event too.
Then it was my turn. I talked and demoed Websheets and Team Development. Where APEX was the Access killer a few years ago, Websheets will be the Excel killer. Websheets changed a bit over time (compared to beta versions I saw); it's now much more a collaboration tool, next to the availability for end-users to work with and share data. I think the wiki functionalities are really good already, for the data part I would like to see some more features in APEX 4.1. If there's one feature I would like to have in there, it's a pivot functionality.
Team Development is a first step into the direction to control your entire projects from within APEX itself. There's still place for improvements (e.g. link with other bug tracking systems), but I strongly believe it will already help many people managing their project in a more structured way.
Olivier Dupont and Jan Huyzentruyt from iAdvise showed other new features in APEX 4.0. They talked about the improvements in Globalization, Interactive Reports, Excel integration etc.
The last presentation of the day was for Iloon Ellen-Wolff. She talked about the enhancements of Tabular Forms in APEX 4.0.
As you can see, the day was packed with sessions :-) This first OBUG APEX SIG day was very technical. In the future we plan to have less technical presentations as well, especially for business people.
I would like to thank everybody who came along for the great atmosphere. Special thanks to Roel Hartman and the OBUG Secretary to help organizing the event.
All the above presentations you can download on the OBUG website.
Posted by
Dimitri Gielis
at
08:37
0
comments
Labels: obug apex sig
Today - blogging day
As I've so many blog posts in my Draft Folder, I decided to try to at least finish a few before the end of today...
Posted by
Dimitri Gielis
at
07:27
0
comments
Saturday, June 26, 2010
ODTUG 2010 - Back in DC after 4 years
In 2006 I went to ODTUG Kaleidoscope for the first time... it was also in Washington DC and in the exact same hotel! It was also my first visit to the US, so it's a memory I'll never forget.
I already blogged in 2006, so it's nice to see what I had to say at that time ;-) (and the World Cup was also going on!)
Now we are four years later and I'm back where my "Oracle Conferences journey" started.
Time goes so fast... four years ago I was a visitor/participant. Now I've a booth with my company and am presenting almost every day...
Posted by
Dimitri Gielis
at
10:27
3
comments
Labels: odtug
WC2010 - DGTournament - Next Round
So far the World Cup 2010 was a bit unpredicted. Teams like France and Italy I expected to go through, but they didn't. That it's difficult to predict the right autcome of a football game is reflected in the stats at DG Tournament.
The next round is starting now, so don't forget to do your bets again!
Posted by
Dimitri Gielis
at
10:21
0
comments
Labels: dgtournament
Wednesday, June 23, 2010
APEX 4.0 goes production
It's finally there... the day we all waited for :-)
You can download APEX 4.0 production release at this very moment.
Posted by
Dimitri Gielis
at
14:51
3
comments
Labels: apex 4
Friday, June 18, 2010
My sites temporarily down
Just a quick note that I'm aware of the problems with my sites e.g. dgtournament.com, apexblogs.info, ...
It's a server issue and we are looking into it.
It should be working again soon.
Thanks for your patience.
Posted by
Dimitri Gielis
at
08:58
0
comments
Wednesday, June 16, 2010
APEX 4.0 Websheets - Behind the scenes
Tomorrow during my presentation about Team Collaboration in APEX 4.0, I'll talk about Websheets. While I was going over my presentation again I came accross two things I thought are interesting.
The first; if you want to search in SQL Workshop for the Websheets table, you want to type APEX$ as they all start with that. However if you type APEX$ in the search it doesn't find the tables. To find the tables you have to escape the $ sign, so your search becomes "APEX\$", then SQL Workshop finds the tables.
Secondly, when you have a closer look at the columns, it's commenly known there are 50 date, 50 numbers and 50 varchar2 columns. But I didn't notice before, there is also a Geocode column in the definition of the table. The last weeks I'm involved in a project that uses Geocodes, so I find it interesting to see there's already something in Websheets for that...
Posted by
Dimitri Gielis
at
21:00
4
comments
Labels: apex 4.0
Monday, June 14, 2010
CD APEX 4.0: Feedback feature and Team Development
This blog post is part of a series posting "Count Down to APEX 4.0 Public Release" (click on link to view history).
In the previous posts we imported our application (and database objects) in APEX 4.0, ran the Advisor to check if the application didn't have any errors and upgraded some components like charts, validations etc. to their new equivalent in APEX 4.0.
We still have some javascript errors in our application and we should now open page by page and see if we have any issues or if we can make better use of the APEX 4.0 features.
We could take a piece of paper to write down all the changes we want to make to the app or use tools like Jira, Fogbugz and many others. Instead I'm going to use the Feedback features of APEX 4.0 in combination with Team Development. This allows me to have a structured plan of the changes I want to make.
We'll create a new (special) page, called the Feedback Page.
We can change the attributes of this page, but we'll just go with the defaults for now.
That's all you have to do to enable feedback for your application. Now people can tell you what they like, don't like and want improved... all that information will appear in the Team Development section of APEX 4.0.
The wizard created a new page and an entry in the navigation bar (which you find in Shared Components). So you can manually do these steps too.
As I already included the Navigation Bar in my custom look and feel of DG Tournament, I literally didn't have to do anything else. I just got the Feedback button (link), which if you click on you get a popup to enter feedback information.
As a default you get the above items on your page, but you can add that like you wish.
The Feedback Type can be off: General comment, Enhancement Request or Bug.
If you look at the Page Process of the Feedback Page you will see the apex_util.submit_feedback package is used to get the data into Team Development.
The most right-side button is Feedback. When we click on that we see a dashboard of all the feedback for the applications in this workspace.
As you can see I entered 3 feedback comments, but I didn't treat the comments yet.
I can now convert the feedback into a bug, a to do entry or a feature.
We'll click on the Feedback tab and see all of the feedback. You have different views of this feedback, you can see open, closed or all and can see the feedback in Extended or Basic modus.
From this screen you click on a Feedback entry
You update the feedback entry and can change the status etc.
That is how I would go forward. I would let people test our migrated application and ask to enter their comments as Feedback. I, as a developer, would do the same. It gives me (and project manager and other developers for larger projects) and the customers insight in what has to be done and we can properly plan.
I didn't touch the Milestones, Features, To-Dos and Bugs, but it's worth to have a look at that aswell. It's all in Team Development.
Posted by
Dimitri Gielis
at
19:17
2
comments
Labels: apex 4.0
Saturday, June 12, 2010
WC2010 - DGTournament - hot
Looking at the statistics you just know something happened yesterday... Yes! The World Cup 2010 started... it looks like people are competitive and care about their ranking ;-)
Three people betted the correct score of the first two games!
This is the top 3 so far at DG Tournament, all with equal points:
- Marco Gralike
- Szabolcs Horai
- Thomas Tomm
Concerning my bets... I almost had it right, but France didn't score and Mexico scored against... so 0 points. Hopefully my next bets are a bit better :-)
Posted by
Dimitri Gielis
at
08:58
0
comments
Labels: dgtournament
Friday, June 11, 2010
Benelux APEX 4.0 day - 20 places left
Just a quick note to say there are 20 places left for the Benelux APEX 4.0 day on Thursday.
Great speakers, great topics, great audience... and a full day about APEX 4.0!
Posted by
Dimitri Gielis
at
09:17
0
comments
Labels: apex 4.0, obug apex sig
WC2010 - DGTournament - Prices to win
I've the pleasure to announce we have some prices to win after all ;-)
You find the prices on the Rankings page of DG Tournament.
Today the World Cup 2010 starts, so if you didn't bet yet, you have a few hours left!
Registering on DG Tournament stays open (it has been open for over the last 4 years), so if you missed the first matches, you can still try to catch up with the others.
At the end I'm happy I enabled the World Cup 2010 football on DG Tournament, as it's way more exciting now ;-) I even bought the EA Sports game of the World Cup 2010! Not sure when I've time to play, but I already played it once in the weekend, and it's a very nice game.
Good luck to everybody! And that the best may win!
Posted by
Dimitri Gielis
at
08:55
1 comments
Labels: dgtournament
Thursday, June 10, 2010
CD APEX 4.0: Utilities - Upgrade Application
This blog post is part of a series posting "Count Down to APEX 4.0 Public Release" (click on link to view history).
In the previous posts we imported our application (and database objects) in APEX 4.0 and ran the Advisor to check if the application didn't have any errors.
As I said yesterday, we are going again to Utilities, but this time we click on the "Upgrade Application" button (second left from the bottom).
The following screen displays the available upgrade types along with the number of objects that can be upgraded. This is the fastest way to make use of the latest features of APEX 4.0 and do a bulk upgrade of the different components (new features).
E.g.
- you can replace the old date picker with a new one
- if a value can't be null, that can be specified native in APEX 4.0, so we won't need to add an extra validation in (like we had to do in APEX 3.x). That is what they mean with the first (Update Value Required Item attribute to Yes)
- enabling a lot of new features for the Interactive Report
- upgrade all your charts (based on Anychart 3) to the new charting engine in APEX 4.0 (Anychart 5)
- ...
So we click on the candidate objects count to review the candidates. First I clicked on the Date Picker upgrade link
We select the ones we want (check box in front of the records) and click the Upgrade button.
It will come back if it successfully upgraded the components.
We can now do the same for the other types. So click on the Upgrade Application Summary link in the breadcrumb (or you can select another type from the drop down), you'll see that the ones that are already upgraded won't appear anymore.
The only thing I would be aware of, is if you used a workaround against a problem (e.g. the Lov's null), you need to make sure you undo that before/after you migrate.
Finish them all and you are ready for the day again... you see the updated app in APEX 4.0 here.
Yesterday Roel knew the answer what my topic of today was going to be... you have an idea what I'll do next? You have more options now, no? ;-)
Posted by
Dimitri Gielis
at
22:49
0
comments
Labels: apex 4.0



