Validating naming conventions in Oracle

Most development teams have agreed upon some sort of naming convention as it typically increases the readability and comprehension of the source code. Defining these rules is one thing, but correctly and consistently applying them is another. Wouldn’t it be great if we were able to actually validate whether our team-specific naming rules have been applied the right way? Well, I’ve created a package that makes it possible to list all incorrectly named elements in your database schema.

Continue reading

Introducing the Oracle APEX Maven plugin

I’m currently in the process of building a Maven plugin to make APEX development even more fun and productive. The primary goal of the Oracle APEX Maven plugin is to streamline and facilitate the build process for APEX applications. That might sound a bit confusing for those of you who are not familiar with Maven or any other build management tool, so let me explain some of the terms I have used so far.

Continue reading

Webinar – Shaping your APEX development process

I’m doing a webinar next week for ODTUG about Shaping Your APEX Development Process on Tuesday February 18th at 12:00 PM EST. It’s the first time for me to talk in front of a virtual audience, so it will be kinda special for me. Click here to register for the webinar. I hope to see you there! Well, see is probably not the right word, but you know what I mean. :]

Here’s the abstract of what I’ll be talking about:

Software development with Oracle Application Express is by no means affiliated with enterprise web development. Oracle itself positions APEX as a so-called rapid application development tool, but recommends other products as soon as projects get larger and more complex. I honestly believe, however, that APEX has the potential to cope with these large-scale projects. But – there’s always a but – you need more than just plain APEX.

Continue reading

The apex.da.resume function

I was reading Martin Giffy D’Souza’s article on the apex.da.cancelEvent function and thought it would be interesting to talk about another undocumented JavaScript function called apex.da.resume. This function is closely related to the Wait For Result setting within a dynamic action. You typically check this option for a so-called asynchronous action that should wait to finish before executing any following, dependent actions. As soon as the asynchronous action gets back the result it was waiting for, the apex.da.resume function is called in the background, which causes APEX to start executing the next action.

Continue reading

APEXExport – a walkthrough

Last week I was struggling to get the APEXExport utility to work. I was messing around with environment variables, different Java versions, and ugly bash syntax while constantly getting the exact same error message. Anyway, after some frustrating moments, I decided to start all over again and then I came up with a solution pretty fast. Here’s my way to quickly get the APEXExport command-line utility to function properly.

Continue reading