Skip navigation.


APEX 5.0 - New Features - Sub Region - Region Position

Denes Kubicek - Mon, 2014-02-03 01:45
One of the first things I checked in APEX 5.0 EA was the region positioning of the sub regions. I was positively surprised to see that I can now position the regions next to each other as well. In earlier versions the only option was underneath. Having this possibility it will be much easier to create complex forms where you need to take care of positioning multiple items in more than one column. At the moment this is doable but somewhat tricky.

Categories: Development

APEX 5.0 - early adopter is cool

Denes Kubicek - Sun, 2014-02-02 06:40
This is definitely the best APEX version ever. I just tested it and it took less than a couple of minutes to get used to it. You know how hard it is to accept major changes. This time it was easy. The changes made in the builder will for sure increase the productivity although this was never a weakness of APEX. There are of course some things missing (or I just couldn't find them) like how to create a simple form. Some features are still not implemented like workspace user management. Some things remained the same like a wizards for page creation. However, I can confirm that it is worth of requesting a workspace and starting to use it. It is simply cool.

This is how the page builder looks like:

And this is a result of my first test:

And here is the link:

Categories: Development

APEX 5.0 (EA) Page Designer video's

Dimitri Gielis - Fri, 2014-01-31 15:10
APEX 5.0 early adopter is about to be released in the public.

Requesting a workspace is not working yet at the time of writing this post, but I expect it can be opened every moment now.

APEX 5.0 carries many new features, one of the biggest is the new Page Designer which should increase developer productivity even more. David Peake recorded some videos, here's the APEX 5.0 Page Designer Overview:

You find more detailed videos for the specific sections of the APEX 5.0 Page Designer on YouTube:

Congrats to the Oracle APEX development team for delivering APEX 5.0! It looks awesome.
Categories: Development

Increase post back size in Glassfish

Dimitri Gielis - Fri, 2014-01-31 09:41
I created a small mobile APEX app for my football team where they can upload pictures to the app.

Sometimes saving the picture worked, sometimes it didn't. If it didn't work I hit the following error: "Post too large". It turned out that my Max Post Size in Configurations - server-config - Network Config - Network Listeners - http-listener-1 under HTTP was set too small.

After increasing it worked like a charm.

Categories: Development

Identifying the Java Thread which is consuming high CPU

Arun Bavera - Thu, 2014-01-30 11:31
In Summary:

  1. Run Top on Linux or Use Process Explorer on Windows to identify the Top CPU Process
  2. Press Shift -H to enable the Thread view or use "top -H -p ". Watch for several minutes to make sure the particular thread is always consuming top CPU%
  3. Convert the top Thread PID to HEX, you can use online tool or Calculator:
  4. Take the several  Thread Dump for the Java PID using jstack or kill -3 when the thread consumes top % CPU to check which method consumes the CPU cycle
  5. Match the HEX Thread in the Jstack thread dump

Here are some of the articles which helps in identifying the High CPU consuming Java threads:

You can also use other tools like Jconsole with plugins, visualVM, Oracle EM JVMD

Categories: Development

Favorite stories: how programmers benefited from my book(s)

FeuerThoughts - Thu, 2014-01-30 05:30
I received this very pleasant note today from a PL/SQL developer:
Actually, the second edition of PL/SQL programming is what jump started my career as a PL/SQL developer. I was sold to my first Oracle customer as an Oracle developer, while I had actually never written any PL/SQL. So I raced to the biggest bookstore in Rotterdam and guess what I found [Steven: the biggest computer book he ever saw? :-) ]. The sad thing is these kind of books cannot be found in physical book stores anymore.  For years I used to visit Barnes & Nobles in WPB and pick up an Oracle book when on holiday. Every year the computer book section would occupy less space, and would recently only offer books on iPhone programming, Excel for dummies and such. This year I didn't even bother. Even my favorite bookstore of all times, Computer Book Centre in Funan Centre Singapore is now on line only.Wow, his favorite bookstore is in Singapore. I like that!

I sure enjoyed my time in Singapore, though bookstores didn't figure much into the visits....

I have to say that I've never been overly concerned about how my books might help a corporation improve its bottom line. But I have always felt very satisfied when I hear how my books may have helped an individual's career.

Oh, this Dutch developer also shared with me his orange bookstack:

Categories: Development

Free Shipping! Free Shipping! Free Shipping!

FeuerThoughts - Sat, 2014-01-18 18:15
If you are one of the many humans who don't believe in evolution, or more specifically believe that the planet is just 6,000 years old, or believe that a God or gods have a plan for us, I wouldn't bother reading any more of this post.

OK, then. So if you are still reading this, I will assume that you have a healthy respect for the scientific method (including, at its core, a constant challenging of its own "theories" - current models for explaining how the world works) and a growing horror at what we humans are doing to our world  and, just as importantly, doing to the millions of other species of living creatures on this incredible planet.

But we shouldn't give up, right? We should do whatever we can, whenever we can, to heal the world from the worst of human ravages, cut back on our consumption, educate our fellow humans about the importance of changing our ways.

Absolutely. But first allow to express a bit of concern about the chance that anything we do will have much impact.

1. "Free Shipping" 

Among the many incredible accomplishments of e-selling juggernaut Amazon is that "visionary" Jeff Bezos has managed to zero out the entire cost of the infrastructure of transportation of products in the minds of consumers. We have become addicted to "free shipping" (hey, and if you pay just $79 for Amazon Prime, free second day shipping) and fully expect that we should not have to pay anything to:

a. Move the product from the factory in China to a truck.
b. Drive the truck to the train.
c. The train chugs its way to a port.
d. A truck takes the product from the train to a container.
e. Container is loaded onto massive cargo ship (holding thousands of said containers).
f. Cargo ship crosses big sea, consuming enormous amounts of fuel.
g. Ship arrives in San Francisco and lets all its ballast water out into the Bay, releasing billions of creatures who do not belong, some of whom will invade and wipe out native creatures.
h. Move container off ship to truck.
i. Truck to train.
j. Train to truck.
k. Friendly Fed-Ex or UPS fellow leaving a box at our door.

All of that, and not only for free, but cheaper than we can get it ANYWHERE ELSE including the store down the street.

Causing this shift in our perspective is no small accomplishment - and has, I fear, nothing but bad consequences.

Seems to me that 2014 is the wrong year (as if 2013, 2012, 2011 or 2010 were any better) for humans to no longer have to pay any attention - or money - for the vast and vastly destructure globalized movement of products.

Not promising at all!

2. "All the News That's Fit to Banner"

It's not hard to find an article or blog post or (even better) a tweet about how our attention spans are decreasing, how young people don't read lengthy books or articles anymore. They are easily distracted and tuned to receiving short bursts of highly packaged data. Yeah, OK, we've heard all that.

And I believe it.

So I found it really striking and downright depressing that none of our major newspapers even include the Environment, Planet, Ecology, Climate Change, etc. as a top-level entry on the banners of their websites. Take a look:



If these hold-outs of reason and deep(er) thinking can't seem to manage to accept the world-killing efforts of humans (also a major killer of humans) as a significant category of news in 2014, then I truly do not find it easy to be optimistic about the chances that we will change our consuming ways.

3. Dolphin and Killer Whale Shows

Well, I am not going to repeat what I already said here, except to say:

The next time anyone sounds off about the superiority of human beings over other creatures, ask them what they think about us enslaving other sentient beings.

Categories: Development

REST, SSE or WebSockets on WebLogic 10.3.6

Edwin Biemond - Wed, 2014-01-15 14:10
WebLogic 10.3.6 comes with Jersey1.9 and has no support for Server Side Events or WebSockets. But for one of our projects we are making a HTML5 / AngularJS application, which need to invoke some RESTful services and we also want to use of SSE or WebSockets. Off course we can use WebLogic 12.1.2 but we already have an OSB / SOA Suite WebLogic 10.3.6 environment. So when you want to pimp your

APEX Training 2014 - Best Practices

Denes Kubicek - Tue, 2014-01-14 03:22
Our next training will be held in Bensheim on 26th of May 2014. You can find the details here.

Die Erfolgreiche Trainingserie geht auch in diesem Jahr weiter. Dietmar Aust und ich organisieren ein weiteres Best Practice Training am 26.05.2014 in Bensheim. Diesmal findet das Training auf der Basis von APEX 4.2 statt. Nutzen Sie die Möglichkeit von Experten zu lernen und melden Sie sich an. Einen Link zu der Anmeldeseite finden Sie hier.

Categories: Development

A little trick with redefining any object in a view from another schema

XTended Oracle SQL - Mon, 2014-01-13 15:49

A couple months ago i used this trick with one of the dba_ views in own query for convenience.
Simple example:

SQL> conn scott/zzzxxx@orasql
SQL> select count(*) from all_catalog;


SQL> with v$enabledprivs as( select -level as priv_number from dual connect by level<=1000)
  2  select count(*) from all_catalog;


As you see, i just redefined v$enabledprivs with subquery factoring clause, and look at the code of “all_catalog” view now:

       decode(bitand(,2151678048), 0,,
              decode(t.ts#, 0, null,,
from sys.user$ u, sys.ts$ ts, sys.seg$ s, sys.obj$ co,$ t, sys.obj$ o,
     sys.obj$ cx, sys.user$ cu, x$ksppcv ksppcv, x$ksppi ksppi,
     sys.deferred_stg$ ds
where ...
  and (o.owner# = userenv('SCHEMAID')
       or o.obj# in
            (select oa.obj#
             from sys.objauth$ oa
             where grantee# in ( select kzsrorol
                                 from x$kzsro
       or /* user has system privileges */
         exists (select null from v$enabledprivs
                 where priv_number in (-45 /* LOCK ANY TABLE */,
                                       -47 /* SELECT ANY TABLE */,
                                       -48 /* INSERT ANY TABLE */,
                                       -49 /* UPDATE ANY TABLE */,
                                       -50 /* DELETE ANY TABLE */)
  and t.dataobj# = cx.obj# (+)
  and cx.owner# = cu.user# (+)
  and ksppi.indx = ksppcv.indx
  and ksppi.ksppinm = '_dml_monitoring_enabled'
Categories: Development

SETI is a Grotesquerie

FeuerThoughts - Mon, 2014-01-13 08:11
SETI - the Search for Extra-Terrestrial Intelligence

I used to be big into sci-fi. I read lots of fascinating stories involving ingeniously crafted aliens. It was very entertaining and thought-provoking.

Like many humans, I looked on with awe as humans found their way into space, peered ever deeper into space (and the universe as it existed long ago), and searched avidly for life on other planets.

Now I find all of that to be a grotesque mockery, since that search for extra-terrestrial life is possible only through our utter disdain for and vast destruction of life on our very own planet.

The only life we know for sure exists.

How many species of frogs, butterflies, trees, bats, birds and myrid others have gone extinct so that humans could establish and operate the vast network of factories, homes, aircraft, trucks, trains and more, required to send rockets (and humans!) into space?

Clearly, humans don't really give a shit about life, in general.

All we give a shit about is us: sentient, self-aware, tool-making us. Special and unique us.

And what we are looking for "out there" are others like us: tool makers, manufacturers, consumers.

If that wasn't the case, if what we really wanted to do was establish contact with other sentients, regardless of how they lived in the universe, so that we could learn from each other, then, let's see:
  • It would be considered murder to kill a whale.
  • It would be considered slavery to keep a cetacean captive (and performing tricks) at places like SeaWorld and Shedd Aquarium.
  • We'd be working awfully damn hard to learn how to communicate with cetaceans.(even if only as practice for the "real thing")
Why do I say this? Because cetaceans are self-aware.
    Cetaceans - whales, dolphins and porpoises - have been evolving for millions of years, just like us. They have big, complex brains. They have language. They recognize themselves. They have a sense of humor, for heaven's sake.

    Repeat after me: cetaceans are self-aware.

    Too bad, then, that they don't make stuff. Because as far as humans are concerned, if you are not ravaging your planet in order to build things to make your lives more convenient and comfortable, then you are a lesser being. And that renders you simultaneously uninteresting (except as a source of entertainment) and available for exploitation.

    And so here it is, 2014, and still our governments can't even agree on enforcing a worldwide ban on whaling, thereby ending the rampant slaughter of these extraordinary creatures (who, we should recall, evolved from land-based mammals, reclaiming a life in the ocean. Amazing!).

    Don't worry, though: even if all the whales are dead, we will still have recordings of their haunting, beautiful songs.

    And we can still take our children to "educational shows" that feature those cute, smiley dolphins leaping on command and wiggling their tail in delight over being fed a fish.

    As if dolphins need humans to feed them fish! This sort of travesty is what passes for the most high-minded, progressive education of our youth.Yuck.

    The fact that humans can't even accept cetacean self-awareness shows clearly that we do not respect life and we do not respect sentience. The only thing we respect is the ability to manufacture and consume things, regardless of the cost to the rest of our planet and its inhabitants.

    C'mon, SeaWorld: let your killer whales go!

    Hey, Shedd Aquarium, close down your abomination, the Abbott Oceanarium!

    Oh, and NASA (and China National Space Administration and India Space Research Organization and European Space Agency and...)? Please shut down operations. Now.

    If we are going to drive to extinction hundreds, probably thousands, of species, and obliterate the lives of trillions of individuals, let's at least commit the resources that result from those deaths to finding a way to reduce the awful impact we have on our world.

    Categories: Development

    Barcode Report

    Denes Kubicek - Sun, 2014-01-12 05:05
    This example seems still to be interesting to some people in the community. The number of requests and questions I am getting regarding it forced me to update it. Now the rendering is using an application process instead of a public procedure - using public procedures in XE is somewhat tricky.

    Categories: Development

    Start learning a new Oracle technology

    Dimitri Gielis - Sat, 2014-01-11 04:31
    I found it very interesting to read Tom Kyte's New Year resolutions for 2014.

    "Learn something new about Oracle almost every day"

    "Learn a new technology outside the comfortable realm of Oracle Database".

    Resolutions I try to follow myself every year...

    I love to try and integrate different technologies with Oracle APEX. Looking back at the last two years, just from the Oracle stack alone, in 2012 I played around integrating APEX with E-Business Suite (see blog). In 2013 I played around with Big Data and Endeca and tried to see how APEX could work with that (see presentation).

    But you might wonder, how do you start with a new Oracle technology?

    You can download and install almost all Oracle software from OTN for free to try-out.
    There's also the Oracle Cloud where you can try their cloud solutions.
    But maybe even easier are the pre-built Oracle VMs. A complete environment with all necessary software installed and some guides to get started.

    In a future post I'll talk about how to learn different technologies linked to web development. In web development things are changing very fast; new (javascript) frameworks, new insights in web design etc. popup almost every day!
    Categories: Development

    To Buy or Not to Buy: FIJI Natural Artisan Water

    FeuerThoughts - Sun, 2014-01-05 06:53

    Here's why FIJI Water thinks we should buy "their" water:

    In Fiji, rainfall filters through volcanic rock over hundreds of years, adding vital minerals that give FIJI Water its unique and refreshing taste. The water collects in an ancient artesian aquifer deep within the earth, where it is protected from external elements. It's the way nature intended water to be. Untouched.

    Here's why I think we should NOT buy this water:

    In Fiji, rainfall filters through volcanic rock over hundreds of years. The water collects in an ancient artesian aquifer deep within the earth, where it is protected from external elements. It's the way nature intended water to be. Untouched.

    So don't touch it, FIJI Water. Leave it the f%$k alone.
    Categories: Development

    New Continuous Integration tutorial published

    Lynn Munsinger - Mon, 2012-07-02 09:44
    Hot off the press – a new continuous integration tutorial. It’s really not just about continuous integration, though! You’ll find it useful even if you aren’t using a continuous integration server like Hudson. It’s useful if you are doing any part of the scenario it documents: Setting up Team Productivity Center for your team and [...]

    Advanced ADF eCourse, Part Deux

    Lynn Munsinger - Tue, 2012-06-19 15:11
    In February, we published the first in a series of FREE(!) online advanced ADF training: The response to that course has been overwhelmingly positive as more and more people are moving past the evaluation/prototype stages with ADF and looking for more advanced topics. I’m pleased to relay the good news that the 2nd part [...]

    Fun with Hudson, Part 1.1

    Lynn Munsinger - Tue, 2012-06-05 09:19
    Earlier I posted that I had used the following zip command in the ‘execute shell’ action for my Hudson build job: zip -r $WORKSPACE/builds/$JOB_NAME-$BUILD_NUMBER * -x ‘*/.svn/*’ -x ‘*builds/*’ This zips up the content of the exported source, so that I can send it on to team members who need the source of each build [...]

    Hiring a Curriculum Developer

    Lynn Munsinger - Tue, 2012-05-15 09:34
    If you are an instructional designer with an eye for technologies like ADF, or if you are an ADF enthusiast and excel at creatively producing technical content, then ADF Product Management would like to hear from you. We’re looking for a curriculum developer to join our ADF Curriculum team, which is tasked with ensuring that [...]

    Hiring a Curriculum Developer

    Lynn Munsinger - Tue, 2012-05-15 09:34
    If you are an instructional designer with an eye for technologies like ADF, or if you are an ADF enthusiast and excel at creatively producing technical content, then ADF Product Management would like to hear from you. We’re looking for a curriculum developer to join our ADF Curriculum team, which is tasked with ensuring that [...]

    New ADF Insider on Layouts

    Lynn Munsinger - Mon, 2012-03-26 13:22
    I’ve published an ADF Insider session that helps de-mystify the ADF Faces components and how to work with them (and not against them), when building ADF applications. There’s also some great information on building ADF prototypes. Take a look here: