Sunday, February 15, 2009


I was lucky enough to be able to attend the UK Oracle User Group's Application Express SIG on Friday - my first experience of any UKOUG event. The event was a "sell out", with all available places taken up well in advance. This in itself is great news, because it shows that APEX really is taking off, which means I can be fairly confident I haven't backed the wrong horse career-wise.

David Peake, the APEX Product Manager, gave the first two presentations:

  • The Latest and Greatest from Development

  • APEX @ Oracle

The first of these was a tantalising glimpse at what will be in 3.2 (coming soon) and 4.0 (coming later this year hopefully). These are described in the APEX Statement of Direction, but we were able to see some of them in a live demo. I am particularly looking forward to 4.0 for its improved tabular forms, and for Dynamic Actions - i.e. a "rich client" experience without having to write any Javascript.

Dimitri Gielis and John Scott from Apex Evangelists both gave interesting presentations, on Charting in Apex and Dispelling Myths about APEX respectively. Dimitri's piqued my interest to go back and look at charts again, and John's provided a lot of useful ammo for fighting against the usual "Apex is just a power user toy" kind of myths.

There was also a presentation from Matt Nolan and Vincent Migue from e-DBA called "Using Apex to Expose your Business to the Web" - and their website is a fine example of that.

After a short Q&A forum, we all went to the local pub, which was a great opportunity to get to know some of these people a little better.

All in all, a great day out (good grief, how sad do I sound?!) and I'd definitely like to attend the next one, should there be one.


Mariah said...

Hello Tony:

i have a problem... hope u can help.

listen, im using a table that has a clob column... over a year i do inserts without empty_clob's
intructions, but... even now im having very big performance troubles.

im doing the next:

into a package i have dinamic information and i have a variable called cuerpo and it type is cLOB.

then ... the clob variable (cuerpo) that has inside HTML code... and then, i make the next insert:

INSERT INTO cto_confirmacion

over a year... this doesnt have any problem... even now... is very very very slow... almost 7
seconds 4 operation before maybe less than a second.

i tried to change:



SET cuerpo = cuerpo
WHERE fol = 1

and the primary key is fol....

even then... is very very slow....

i dont know what to do... im very worried.

I have to say that the string into my clob variable has a length of almos 5000 characters... can this make a difference in the way to make inserts???

Thanks 4 anything.


Tony Andrews said...


I'm sorry, but I don't have any ideas for you about your CLOB problem. Why not try posting a question on one of the many forums out there? e.g.,, to mention just 3 that I regularly visit.