donderdag 23 december 2010

APEX Patch Set

It's a re-release of
+ One Off Patches 10347091 and 10406645


dinsdag 21 december 2010

End of Year

It was a wonderful year.
Highlight of the year was Application Express 4.0!
Application Express is a wonderful and powerful product!

The new statement of direction of Application Express makes me happy too.
New statement of direction

I enjoyed the different APEX conferences very much and hope to meet you face to face at one of the conferences.

Looking forward to the new challenges in 2011!

Merry Christmas and Happy and Healthy 2011 for you and your family!

Thank you all for the wonderful year!

maandag 20 december 2010

Installation of APEX 4.0.2 with Oracle 11g Failed - ORA-43853

APEX version 4.0.2 Fresh Installation
Table Space were Application Express is installed: MANUAL

ERROR at line 1:
ORA-43853: SECUREFILE lobs cannot be used
ORA-06512: at line 7

What works
* Installation from APEX version 4.0.2 against Rdbms
* Installation from APEX version 4.0.2 against Rdbms with Table Space set to AUTO were Application Express is installed

Underlying Cause
A difference in the behavior exists between the and databases and the underlying space management of table spaces. When installing APEX, the underlying table space were APEX is to be installed must to be set to AUTO.

Set the table space were APEX is to be installed to AUTO.

vrijdag 3 december 2010

UKOUG Conference 2010

This year, I attended for the first time the UK Oracle User Group.
The UK user group is the biggest in Europe.

The UK user group has many different tracks available. ( Server/ Fusion Middleware/ APEX/ E-business suite/ MySql etc)

I cannot choose between ODTUG in the US and UK Oracle User Group.
The best people around the world are presenting.
Therefore, I was extra honored to be a speaker at this conference!

During the conference, I attended many different kind of sessions in different kind of streams.
To broadening my knowledge, I also attended sessions dealing about ADF.

My presentation was scheduled at Tuesday and I was a little bit concerned because it was the last presentation of the day. I was very happy with the amount of people in my room.

I also like to take the opportunity to congratulate John Scott with the well deserved 'presentation award 2009'!
John is awarded for his 'Scalability in APEX' presentation.

In the evening, I joined the dinner with APEX Development team.

I really hope to come back next year!

vrijdag 8 oktober 2010

Service Dogs

I want to bring under the attention service dogs.
A service dog is doing very good work for handicapped people.
Service Dogs Information

There is a special event at the 17th of October in the Netherlands to sponsor charities.

vrijdag 1 oktober 2010

UKOUG 2010 abstract selected for conference

I am very honored that one of my abstracts is selected for the
UKOUG Technology Conference in Birmingham.

My presentation will deal about security in application express. A multi layer architecture is used in application express and therefore you need to take care for security in all the layers.
The main goal is to make you aware of security and to avoid the data will be 'hacked'

UK Conference

Many thanks to Dimitri Gielis for making this picture.

maandag 13 september 2010

APEX Celebrity Seminar in The Netherlands

Last week, I taught the application express seminar for customers in the Netherlands.

My seminar

It was a day with a lot of information of the new version of application express.

I am very proud on the evaluation results and therefore very satisfied with the result!

maandag 23 augustus 2010


Application express
For application express 4.0

For 3.2.1 or earlier installed

See: Joel Kallman his blog for details

Apex Listener
Apex Listener

Stand alone feature included.

zondag 15 augustus 2010 is now running version which should fix all the bugs on the known issue list.

dinsdag 6 juli 2010

ODTUG conference

This is the best conference I ever attended.
The quality of the presentations is VERY high and I enjoyed very much.
I need to come back next year!

During the conference, the APEXLISTENER came in production.
About my experiences and solutions, I will blog later on during the week.

woensdag 23 juni 2010

Application Express 4.0 in Production

Yesterday, application express 4.0 is officially released.
This feels like my birthday!

How to start

Building a Websheet in Application Express 4.0 {New}
Building Dynamic Actions in Oracle Application Express 4.0 {New}
Extending your Application Using Plug-Ins in Oracle Application Express 4.0 {New}
Building Charts, Gantts and Maps with Oracle Application Express 4.0 {New}

And many other new features.

Installation /Migration
Please read the installation guide carefully

Oracle Application Express 4.0 requires: An Oracle Database version or higher

Note: You can upgrade the version of Oracle Application Express in
Oracle Database Express Edition 10g Release 2 (10.2), by installing
Oracle Application Express version 4.0. For more information, see the
Oracle Application Express page on Oracle Technology Network

Make a backup from the database before installing the new version.

zaterdag 19 juni 2010

Apex SIG In Antwerpen 17th of June

It was the first Apex SIG in Benelux organized By Dimitri Gielis and Roel Hartman.

It was a wonderful day and a very complete overview of application express 4.0.
Everybody who has not been there has missed a lot.

The development and maintainability of applications in application express is much easier and improved!

Excellent work from apex development team.
It is amazing!

Presentations, will come available soon at the OBUG website!

Hope to see you again at the next Apex OBUG SIG. upgraded upgraded to, plus all languages loaded.

See for details

zaterdag 5 juni 2010 migrated to version 4 is migrated to 'pre production' version 4 during the weekend.

See for extra details:

Have fun.

zondag 30 mei 2010

World Cup 2010

Dimitri Gielis created an excellent application for this tournament.

Tournament application

You can also play with your own company.

When everybody of your company has the same location entered,
you have the possibility to filter on the location!

It is really fun to play!

donderdag 27 mei 2010

Pl/Sql Challenge Blog

Sometimes, I am very surprised with the answers from the Pl/Sql Challenge.
It is a nice way to improve your pl/sql skills

I am happy, a a blog is created about the challenge

I was also surprised with the CHR(10) in UTL_FILE

woensdag 19 mei 2010

Pl Sql Challenge

Very nice to start the day with
Pl Sql Challenge of the day

It is a nice way to test your Pl/Sql knowledge

woensdag 12 mei 2010

Apex Early Adopter Release 3

Application Express Early Adopter Release 3 available now!

Have Fun

donderdag 6 mei 2010

Oracle Learning Library

Learning Library
This is a directory listing of free online training from Oracle - Oracle By Examples, Tutorials and Demonstrations from different Oracle Products

Important Events in June

Tuesday June 8th
Sneak Preview ODTUG at Amis office in Nieuwegein

Registration form

Tuesday June 15th
Oracle Application Express Conference in Dublin

Conference details

Thursday, June 17th,
The first official OBUG APEX SIG event is scheduled.
The location will be conveniently located for all attendees from Belgium, The Netherlands and Luxembourg, somewhere in or around Antwerp.

All sessions, will deal about application express 4.0

Registration Form

ODTUG Kaleidoscope
27th June - 1 July 2010