Yet Another Post How to Link to Download a File or Display an Image from a BLOB column

On an internal mailing list, an employee (Richard, a long-time user of Oracle Application Express) asked:

"...we are attempting to move to storing (the images) in a BLOB column in our own application tables.  Is there no way to display an image outside of page items and reports? "

Basically, he has a bunch of images stored in the BLOB column of the common upload table, APEX_APPLICATION_FILES (or WWV_FLOW_FILES).  He wishes to move them (more...)

APEX 5.0 Page Designer Videos

There is a nice series of videos regarding APEX 5.0 Page Designer on YouTube. You can watch it here. David Peake is showing how the new Page Designer works. It is worth of having look at it and much easier that finding it out yourself. Enjoy.

APEX Plugin Page

I just noticed that http://www.apex-plugin.com is programmed using php and jomla. Shouldn't it use Oracle APEX?

APEX IR Query Plugin

I already posted about the function for getting the IR query here:

http://www.deneskubicek.blogspot.de/2013/05/getting-interactive-report-query.html

Now, I decided to create a dynamic action plugin based on that function. The plugin has been submitted to the plugin directory at http://www.apex-plugin.com/ and should appear there soon. If you want to see how it works and download the code, you can do it here as well: https://apex.oracle.com/pls/apex/f?p=43045:1

Oracle APEX Cookbook : Second Edition

I was asked to review this book and write a couple of words about it. Of course I didn't go through all the 444 pages of the book because I don't have enough time. From what I could read and review, I can say that this book contains a lot of well explained examples for almost all APEX features. So, if you are new to APEX and want to speed up your learning process then (more...)

Finally…the official sizing guide for Oracle Application Express

The following question was recently posted on an internal mailing list:
"Is there a sizing/capacity/scalability guide available for APEX?"
I'm always fascinated by this question.  I appreciate the fact that this is a standard, acceptable practice in the industry, and people come to expect it.  How else could architects and planners appropriately allocate resources without some form of estimate?  This impacts capital expenditures and budgets and rack space and energy costs and support costs (more...)

New APEX Certification Exam BETA Now Running

How does a prospective employer  or customer know that you are any good at developing with Oracle Application Express?
One of the best credentials, to prove you have APEX chops, is to obtain Oracle Application Express Certification!

The APEX Certification Exam has undergone a large upgrade.
Much of the content being rewritten / improved as part of this effort.
The new exam is currently running a BETA program until 10-May-2014.
Testing centers are available worldwide.

APEX Listener => Oracle REST Data Services


Yesterday a new version of the Oracle APEX Listener was released. The new version is 2.0.6... and the biggest change in this release is the change in name. From now on we won't speak about the "APEX Listener" anymore, but we speak about "Oracle REST Data Services".

The name explains more what the piece of software is doing and it will be less confusing for non-APEX people. Many people thought about the Database (more...)

Working Orange

On Thursday, February 27th, I will be taking over @WorkingOrange - the Syracuse University Career Services Twitter account.


WorkingOrange was created to allow Syracuse alumni from all fields to share what it is they do on a typical day, as well as interact with students, other alumni and anyone else.  It is typically active each Tuesday and Thursday, and has hosted alumni from all kinds of industries.  For example, today is an elementary school teacher, (more...)

APEX Evangelists Network Welcomes Paul Broughton

As I recently blogged, APEX Evangelists is undergoing a transformation (stay tuned for what that means for me).

We are very happy to announce that Paul Broughton (Twitter - @paulbroughton) has joined the AE Network!

For those of you who don’t know Paul, he started working for APEX Evangelists back in July 2009 (wow time flies!) and has been involved in many client facing projects (and very recently was presented with an award (more...)

Narrow result set for APEX IR alternative default reports in query

How to use interactive report alternative default report alias in query to narrow result set in APEX 4.2

Oracle APEX Listener – support for Apache Tomcat

The Oracle APEX listener is one possible gateway to run Oracle Application Express besides the Oracle http server (OHS), the embedded pl/sql gateway (which is the http server included in the Oracle database as part of the XML DB) and other open source alternatives.

Being implemented as a J2EE application it needs a servlet container to be deployed in. Finally, due to popular customer demands, the Apache Tomcat servlet container is (again) supported. Many customers (more...)

Yet another way to create “editable interactive report”

How to create interactive report where user can edit data using APEX 4.2

Some help with the Oracle APEX Theming Competition 2014

ODTUG announced a few days ago the Oracle APEX Theming Competition.

Make an awesome APEX theme and you may win some cool prices!

In the Learning Resources on the ODTUG site you will see a reference to my presentation of last year "Advanced Responsive Design in APEX". In that presentation I showed a lot of live demo's from different aspects of Responsive Design: here's a quick overview of what I covered:


I made (more...)

The evolution of APEX Evangelists

Every year we at APEX Evangelists come together to discuss the past and the future of the company.
In the past 7 years a lot has changed; the APEX market changed, the community changed, we personally changed, …

We really like APEX, we are all passionate about it, we love to have technical discussions with each other and come together to share our thoughts, but we also like our independence and make our own trade-offs (more...)

The evolution of APEX Evangelists

Every year we at APEX Evangelists come together to discuss the past and the future of the company.
In the past 7 years a lot has changed; the APEX market changed, the community changed, we personally changed, ...

We really like APEX, we are all passionate about it, we love to have technical discussions with each other and come together to share our thoughts, but we also like our independence and make our own trade-offs company (more...)

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.

You can’t do this as you would with other page items (i.e. just submit the page and have the values stored in session state). Any value over (more...)

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.server.process  (more...)

APEX 5.0 (EA): CSS Calendar

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

The CSS Calendar is based on Full Calendar 1.6.4, at the moment of writing, the current latest production release. The creator of this JQuery plugin, Adam Shaw, is currently working on version 2. A few days ago he released beta 2. It remains to be seen which version of Full Calendar will make it in the final (more...)

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":


The next step looks like this:


The Page Mode can now be set to Modal, so instead of a popup it will render as a modal.

Note that in the EA1 version there are some known issues with the Feedback Page, (more...)