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.
@eddieawad Fixed checked in for the patch.In the meantime, just remove that line in the config— krisrice (@krisrice) December 27, 2012
@eddieawad Now it’ll just put a log entry saying bad config param for anything non-numeric in that spot and ignore empty values— krisrice (@krisrice) December 27, 2012
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.1 Comment | Filed in Oracle | Tags: apex, sql-developer
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:4 Comments | Filed in Oracle | Tags: apex
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.Comments Off | Filed in Oracle | Tags: apex
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.2 Comments | Filed in Oracle | Tags: apex, video, webservice
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).
The following is a screencast to demonstrate:
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:Comments Off | Filed in Oracle | Tags: apex, howto, video
Joel Kallman lists steps to make apex.oracle.com 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 apex.oracle.com fast (again).Comments Off | Filed in Oracle, Tips | Tags: apex
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: apex
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: http://10.10.2.132:8080/apex/f?p=100. 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> using '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp) (HOST=ENTORA_db)(PORT=1521))(CONNECT_DATA=(SID=ENTORA)))' /
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; commit;
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: apex, Security, tool, xe