view counter

APEX Feed

Oracle Application Express (APEX) resources, news, and support articles.

Setting and retrieving CLOB values in Apex

Imagine you have a textarea in your app where you want your users to be able to type in large quantities of text, click a button to store this in the database and then later retrieve this large quantity of text and redisplay it in that textarea.

Passing more than 10 values with apex.server.process

You may be familiar with the apex.server.process function exposed by Apex’s Javascript API. It allows you to asynchronously interact with Apex Application Processes.

A simple example would be.

 

Apex Application Process

HTP.p(‘You passed “‘||APEX_APPLICATION.g_x01 ||’” as the value for x01. ‘);

HTP.p(‘You passed “‘||APEX_APPLICATION.g_x02 ||’” as the value for x02. ‘);

HTP.p(‘You passed “‘||APEX_APPLICATION.g_x03 ||’” as the value for x03. ‘);

 

Javascript

APEX 5.0 (EA): CSS Calendar

APEX 5.0 allows you to create a new Calendar type, called CSS Calendar.

APEX 5.0 (EA): Feedback Page

One of the first things I do when creating a new application is enabling the feedback mechanism in combination with Team Development.
Click the Create Page button in Application Builder and select "Feedback Page":

APEX 5.0 (EA): Creating a new application

Lets see how creating a new Database application works in APEX 5.0 and what was changed compared to APEX 4.2.

In the Application Builder you start by hitting the Create button.

Upcoming Conferences for 2014

It’s that time of year again: Conference Season!  There’s a few conferences that fall in the 1st few months of the year that I try to present at each year, and this year is no different.  Here’s where I’ll be presenting at over the next few months:

You don't have to wait for APEX 5 for FullCalendar Integration

One of the MANY nice things that is coming in APEX 5.0 is the native integration of the jQuery based FullCalendar, known in the APEX 5.0 Builder as the CSS Calendar. While the native integration will be nice, you shouldn't have to wait for APEX 5.0 for this functionality.

Enter the Enkitec FullCalendar plugin. We integrated FullCalendar into our website quite some time ago to enable us to display our Education and Conference calendars. Recently I've taken the basis for that code and created a plug-in that works with APEX 4.1 and 4.2.

APEX 5.0 (EA): Overview

Now that APEX 5.0 EA is out, it's time to do a deep dive in the new features of this early adopter (EA) release.

APEX 5.0 - New Features - Sub Region - Region Position

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.

APEX 5.0 - early adopter is cool

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.

view counter