News, views, tips and tricks on Oracle and other fun stuff

SQL Developer/APEX Listener Bug and The Power of Social Networking in Action

Have you installed or recently upgraded to Oracle APEX Listener 2.0? Have you used SQL Developer 3.2 to manage APEX Listener settings? If you answered yes to both questions then you are in for an unwelcome surprise.

The surprise is that you’ll get a “500 – Internal Server Error” whenever you upload a file via any of your APEX apps or import files via the APEX Application Builder.

Kris Rice responded to my tweet almost immediately.

The problem was a bug in the way SQL Developer uploads APEX Listener settings to the server.

This Oracle forum post describes how to reproduce the bug and the workaround to fix it.

Kris quickly put a fix together and checked it in for the next patch.



If you are still hesitant to join Twitter, I hope that this post has given you an incentive to join this growing social network. Many Oracle employees, like Kris, are active on Twitter and listening to people like you and me who use their products on a daily basis.

To make it easier for you to follow Oracle people on Twitter, I have created this Oracle list. The list occupies a permanent column on my Tweetdeck stack.

1 Comment | Filed in Oracle | Tags: ,

If You Have Oracle Database You Have Oracle Application Express; Use it or Lose it

I’m starting to like Oracle Application Express (APEX) more and more every day.

I have used APEX to build a dashboard to monitor and report on all Oracle E-Business Suite (EBS) interfaces with external systems.

I am currently working on another dashboard for EBS concurrent programs. For that one I used APEX charts. They are really powerful and versatile. Here is a tutorial on how to use them.

The best thing of all, if you know SQL and PL/SQL you’ll be up to speed on APEX in no time.

Oracle recently published the Oracle Application Express statement of direction (SOD). I am very happy to see that Oracle continues to invest in the development and support of APEX and that new versions of APEX will be released annually.

In fact, the next new version will be 4.2 and according to the SOD, this upcoming version is planned to incorporate the following features:

Continue reading…

4 Comments | Filed in Oracle | Tags:

How to Download BLOB Content as a File Using Oracle Application Express

In a previous article, you learned how to create a simple Oracle Application Express application to store the content of any file into a BLOB column in the database.

In this article, you will learn how to include in a report a file download link to the content stored in a BLOB column. If the BLOB contains an image, you’ll learn how to display it in the report as well. Application Express makes this functionality extremely simple to implement.

Continue reading…

Comments Off on How to Download BLOB Content as a File Using Oracle Application Express | Filed in Oracle | Tags:

Using Web Services in Oracle Application Express [video]

Have you utilized SOAP or RESTful Web Services in your Oracle Application Express application? If not, Marcie Young, consulting curriculum developer at Oracle, shows you how. It’s easy and all wizard driven [Docs].

In the following three screencasts, Marcie goes through the steps to create and use a manual SOAP Web Service reference as well as a RESTful Web Service reference with and without a bind variable.

Continue reading…

2 Comments | Filed in Oracle | Tags: , ,

Create an Application to Upload Files Using Oracle APEX, In Less Than 10 Minutes (Video)

A BLOB data type stores unstructured binary large objects. A table column with a BLOB data type can be used to store all types of files such a documents, spreadsheets, images and plain text. You can manage BLOB columns by easily adding file upload and download functionality to a form you create using Oracle Application Express (APEX).

APEX includes declarative BLOB support that enables you to declaratively upload files in forms, and download or display files in reports (ittichai wrote about it here).

The following is a screencast to demonstrate:

  • how to create a simple APEX application to store the content of any file into a BLOB column and
  • how to save the content of that BLOB into a file on the database server.

I recorded the screencast on Windows 7 and Oracle APEX 4.0 that comes pre-installed with Oracle Database Express Edition 11g Release 2.

But first, here is the code that I used in the screencast:

Continue reading…

Comments Off on Create an Application to Upload Files Using Oracle APEX, In Less Than 10 Minutes (Video) | Filed in Oracle | Tags: , ,

Oracle EBS Customization and Extension – OAF vs ADF vs APEX vs Forms

Andries Hanekom:

The E-Business Suite Technology Group recently released a whitepaper: Extending E-Business Suite 12.1.3 using Oracle Application Express. In summary, “This new whitepaper outlines how to extend Oracle E-Business Suite 12.1.3 (and higher) functionality using Oracle Application Express. Recommended architecture and security considerations are discussed in detail.” For some time now EBS customers have used APEX to extend EBS, with the release of this whitepaper the EBS Tech group has acknowledged the growing use of APEX to extend EBS and have provide recommendations and guidelines for integration.

What’s this all about some might ask, is Oracle moving to incorporate APEX as part of the standard EBS tech stack? What about OAF? Isn’t Fusion Applications build on ADF, so what’s up? Well when it comes to Oracle EBS extension and customization, OAF is till the top dog, the E-Business Suite Technology Group continues to recommend OAF for EBS extensions.
Comments Off on Oracle EBS Customization and Extension – OAF vs ADF vs APEX vs Forms | Filed in Links, Oracle | Tags: , , ,

6 Tips For Making Oracle APEX Run Faster

Joel Kallman lists steps to make run faster, like turning on the KeepAlive setting in Oracle HTTP Server, reducing the open window for Web crawlers in robots.txt, replacing a Database Access Descriptor with an httpd.conf rewrite rule and increasing file system caching and memory size. Read the details at Making fast (again).

Comments Off on 6 Tips For Making Oracle APEX Run Faster | Filed in Oracle, Tips | Tags:

Get All the Cool New Features of Oracle Application Express 3.0 in Oracle Database XE

If you use Oracle Database 10g Express Edition (Oracle Database XE) you already have Oracle Application Express (Oracle APEX) release 2.1, it’s part of the XE installation. However, in order to use the many new features of the latest release of Oracle APEX, you need to upgrade APEX, within your Oracle Database XE, to version 3.0.1.

Justin Kestelyn, OTN Editor-in-Chief, blogged about this topic a couple of weeks ago. In reply to a question about the licensing fee of APEX, Justin mentioned that “you can develop a production Apex-based app on XE for free, subject to the terms of the XE license”.

A few days ago, I followed the instructions in this document to upgrade APEX within XE on my Windows Vista laptop. The upgrade was very smooth and took about 20 minutes to complete. I also wanted to test Jing, a new and simple screencasting tool, so I recorded the upgrade process as a 5 minute screencast: Continue reading…

4 Comments | Filed in Oracle | Tags:

I use Oracle Database 10g Express Edition to …

I like Oracle DB XE, not only because it is free and has all the power of an Oracle database, but also because it comes with Application Express, or APEX (formerly HTMLDB). I plan to learn APEX and use it as an ad hoc application builder for such applications that can be shared among team members or on the company’s Intranet.

I installed the demo Web Services application that comes with APEX. For testing purposes, I wanted to allow my coworkers access to this demo application on my Oracle DB XE instance on my PC. Not a big deal, I just gave them the URL to the application, something like this: But, they could not connect to the application.

Well, I discovered that there was a setting called “Manage HTTP Access” under the Administration section of APEX. By default, this setting was set to “Available only from local server”. I switched it to “Available from local server and remote clients”. Now anyone who is on the same network as my PC, is able to access the application.

Of course, if you are exposing access to the whole Internet, you may think twice before doing this. But since I’m sharing the application only among my team members and only inside the company’s firewall, I was not paranoid about security.

Another thing I find useful is to use my Oracle DB XE instance as a tool to load CSV or XML data to another non-XE database (or even XE) through database links.

Assuming you have a non-XE Oracle database instance called ENTORA, and you have a table in a schema in the ENTORA database that you want to populate from data in a CSV file. There are many ways to do that, here is one way to do it using your local Oracle XE instance.

First, in XE, you create a database link to ENTORA. Something like:

create database link ENTORA
  connect to <username> identified by <password>

Then, using APEX, you load the CSV file into either a new table or an exiting table. Loading the data into an Oracle XE user table is just a few clicks away.

Once you have the data loaded in the table, you could do this (connected to user@XE):

insert into t@ENTORA select * from t;

I’m assuming that both t@ENTORA and t@XE have the same structure and DB users have the right privileges.

Poof! Your CSV file is loaded into a table on your non-XE Oracle database.

For more Oracle DB XE benefits, check out Lewis Cunningham’s article on OTN: Oracle Database 10g Express Edition: Not Just for Learners.

If you have downloaded and installed Oracle DB XE, what do you use it, or plan to use it, for?

5 Comments | Filed in Oracle, Tips | Tags: , , ,

YANC – Yet another name change

First, Oracle HTMLDB was renamed to Oracle Application Express. Now, it looks like Oracle Project Raptor is going to be renamed to SQL Developer (Express?), as noticed in Sue Harper’s presentation at ODTUG.

2 Comments | Filed in Oracle | Tags: ,