I was looking for a development tool that I can use with Oracle’s Application Express (Apex) and have found out about this APEX Builder Plugin. The Plugin which is a JavaScript file and have a different installer script for each FireFox and Internet Explorer.
Currently the APEX Builder Plugin is release 1.9. The Plugin is an […]

I have blogged about trying to find out what was wrong with the Oracle Application Express 3.1 installation. Comments and email have confirmed there was something wrong. Plus, my own experience in the installation of Oracle Application Express 3.1 (Apex) on a fresh install of Oracle Database Express Edition (Oracle XE) Release 10.2.0.1.0.
I followed […]

An application created using Oracle Application Express can only be run under the local machine (eg. http://localhost:8080/apex/ or http://127.0.0.1:8080/apex/). It would be nice if the applications developed with Oracle Application Express could be accessed by other computers across the Intranet or Internet. So, I was wondering if it is ever possible to publish web applications […]

I am looking for an alternative operating system to Red Hat Enterprise Linux for use as Oracle Database Server running Oracle Application Express 3.1. There are a number of choice which are certified by Oracle to run the Oracle Database 10g Release 2.
Operating systems certified for installation of Oracle Database 10g Release 2:

SLES-9
SLES-10
Red Hat […]

The cause for missing image and JavaScript error as written before regarding Oracle Application Express Missing Images And JavaScript Error was the wrong image prefix.
http://127.0.0.1:8080/apex/TEMPjavascript/apex_ns_3_1.js
http://127.0.0.1:8080/apex/TEMPjavascript/apex_get_3_1.js
http://127.0.0.1:8080/apex/TEMPjavascript/apex_get_3_1.js
http://127.0.0.1:8080/apex/TEMPjavascript/apex_builder.js
http://127.0.0.1:8080/apex/TEMPcss/apex_3_1.css
http://127.0.0.1:8080/apex/TEMPcss/apex_builder_3_1.css
http://127.0.0.1:8080/apex/TEMPhtmldb/apex_logo.gif
The correct installation should have “/i/” instead of “/apex/TEMP”.
http://127.0.0.1:8080/i/javascript/apex_ns_3_1.js
http://127.0.0.1:8080/i/javascript/apex_get_3_1.js
http://127.0.0.1:8080/i/javascript/apex_get_3_1.js
http://127.0.0.1:8080/i/javascript/apex_builder.js
http://127.0.0.1:8080/i/css/apex_3_1.css
http://127.0.0.1:8080/i/css/apex_builder_3_1.css
http://127.0.0.1:8080/i/htmldb/apex_logo.gif
Thus to correct this problem the prefix image should be corrected. It’s good that Oracle Application Express comes with Useful Oracle APEX tools […]

I am reviewing some error brought to my attention by Zarbarey and Gan regarding Installing Oracle Application Express 3.0.
Good moring.nice info. :)im new to oracle and i tried installing it in my laptop. I follow the instruction above and successfully see the last message below. when I load the oracle home again. I get js […]

After installing Oracle Database Application Express 3.1 you might wonder where to go and how to start.
Here are the links to start with incase you have not noted it during installation process.
Application Express administration services link is as follows:
http://host:port/pls/apex/apex_admin (Oracle HTTP Server with mod_plsql)
http://host:port/apex/apex_admin (Oracle XML DB HTTP listener with the […]

I have been testing if Oracle Text works after installing Oracle Database Express Edition. To check if Oracle Text is installed just query the all_users table to see if CTXSYS username is listed. CTXSYS (Oracle Text) is a schema out of the box for 10g and above. It is used for searchable online help in […]

In the institution that I work, we have a Student Information System. The is powered by Linux RedHat Advance Server. The system is configured in such a way that separate server machines for Apache webserver and Oracle database server. This way public traffic is limited to the webserver only and database access are from internal […]

Outlined below is a way of extracting data from an Oracle database in XML format. After extracting the data it is exported to a text file.
Extracting the data into XML format is done using the following Oracle commands XMLElement, XMLForest, XMLAGG.
To export the data to text file a simple spool command is used.
Here is a […]

Having error that consistently appears on every computer would I say easier to deal but with an error that occurs on one but one another is okey it drives me crazy. I have encountered this kind of error with a Microsoft Access file which is stored on a file server. The MS Access file is […]

 A sample screen shot of the finished Oracle Application Express OEHR exercise sample application is included to picture out the final output of the project.

This particular screen shows the Employee page.  The capabilities include a department select list which will automatically show the list of employees under the selected department. Employee data about first name, […]

A sample screen shot of the finished Oracle Application Express OEHR exercise sample application is included to picture out the final output of the project.

This particular screen shows the Department page. The capabilities include a search box and a change in number of display list per page. Department data about id, name, employee count, […]

Outlined here are the basic steps in building an Oracle Application Express application. The purpose of this is to show the various possible things that can be done with Oracle Application Express.

Creating an Initial Application
Modifying the Departments Report
Adding an Employees Report and Form
Editing the Employees Report
Displaying Items as Select Lists
Adding a Link on the Home […]

December 18, 2007 - Oracle Application Express Class Schedule
Morning Session:
Getting Started with Oracle Application Express

Downloading, Importing, Installing Oracle Express OEHR Sample Application Objects
Viewing Database Objects Using SQL Workshop

Building an Oracle Express Application

Creating the Initial Application
Modifying the Departments Report
Adding an Employees Report and Form
Editing the Employees Report
Displaying Items as Select Lists
[…]

Learning Oracle Application Express will be easier if done with a sample application. The purpose of this page is to facilitate information on downloading and installation of Oracle Express Human Resource (OEHR) Sample application.
To use the OEHR Sample Objects application, it should be downloaded from the Oracle Technology Network (OTN):
Downloading OEHR Sample Application Objects:

Using a […]

Users under a workspace can be organized into various user groups having different roles and purpose.
To create a group:
First, log in to Oracle Application Express:
1. Please see: How to Login to Oracle Application Express 3.0.1 Workspace Admin, Developer, Users Page
2. Under Login, enter your Workspace Administrator login credentials.
3. Click Login.

After creating the workspace we need to log in to your local instance of Application Express.
The following information will be helpful:

URL where you can access Application Express
Workspace name you use to develop applications
Username set up for you for this workspace within Application Express
Password set up for you for this […]

After login to the Application Express Administration Service Page the first thing to do is to create a Workspace. A workspace is a shared work area within the Oracle Application Express development environment that has a unique ID and name. All users in the workspace can access all its applications and scripts. How do we […]

December 17, 2007 - Oracle Application Express Class Schedule
Morning Session:
Oracle Database XE installation
Oracle Application Express Installation

Windows XP Installation Requirements for Oracle Application Express 3.0
Installing Oracle Application Express 3.0
Post-installation Task for Oracle Application Express 3.0
Installing Application Express 3.0.1 Embedded PL/SQL Gateway (apex_epg_config.sql)
Resetting Application Express 3.0.1 Admin Password
How to Login to Oracle Application Express 3.0.1 Administration Services […]

One of the task to be done after an Oracle Application Express installation on an Oracle Database XE or Oracle Database 11g and above is the configuration of the Application Express 3.0.1 Embedded PL/SQL Gateway.
To install Embedded PL/SQL Gateway:
1. Change your working directory to $ORACLE_HOME/apex.
ex. C:\apex>
2. Start SQL*Plus and connect to the database where […]

Missing icons could be one of the problems after a new install of Oracle Application Express. As shown in the example.

When Application Express has missing icons this could mean conflicting or improperly set images folders aliased by the system. This maybe a result of error during installation or some unfinished post installation procedures like setting […]

One needs to access the Administration Services page to manage all aspects of the Application Express service including creating, removing, and managing workspaces. Sometimes the password is not just working. This is the case after a new install of Application Express or when the password is lost.
A new installation of Application Express needs to […]

After installing Oracle Application Express there’s no clear instruction where to login for workspace administrator, developer, and user. The login URL for the said application express users is not sometimes clear.
Application Express normal users’ page could be accessed using the browser on the following URL:
http://yourserver:port/apex/f?p=4550:1
example:
http://127.0.0.1:8080/apex/f?p=4550:1
I hope it works for you.

After a successful Oracle Application Express 3.0.1 installation, the problem arises on: How to login to the Application Express Administration Services page? This is important, as the interface will be used by the administrator to manage all aspects of the service including creating, removing, and managing workspaces.
Application Express Administration Services page could be […]

Oracle Application Express Post-installation task:

Restart Processes(ex. listener, etc.. )
Choose the HTTP Server
Configuring the Embedded PL/SQL Gateway
run apex_epg_config.sql passing the file system path to the base directory where Application Express was unzipped.
if apex_3.0.zip was unzip in C:\oracle\product\10.2.0\db_1\
ex. @apex_epg_config C:\oracle\product\10.2.0\db_1;
Unlock the ANONYMOUS account
ALTER USER ANONYMOUS ACCOUNT UNLOCK;
Verify Oracle XML DB HTTP Server Port
ex. SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
Enable […]

Just as a preliminary, to work around the access to “apex_admin” you can perform the following steps:
(1) Go to you ApEx installation folder (where apexins.sql is located.
(2) log into sqlplus as sys
(3) ALTER SESSION SET CURRENT_SCHEMA = FLOWS_030000
(4) @builder/f4050
*note, I also ran @builder/f4550 and @builder/f4700 by accident and these were probably not needed
(5) close sqlplus
(6) […]

Steps in installing Oracle Application Express:

Download apex_3.0.zip file
Unzip apex_3.0.zip
Copy extracted directory “apex” to $ORACLE_HOME\
ex. $ORACLE_HOMEC:\oracle\product\10.2.0\db_1\
 Change working directory to apex
ex. cd C:\oracle\product\10.2.0\db_1\apex
start sqlplus and connect as SYS
ex. sqlplus sys/ as sysdba
run apexins.sql with the following five arguments
- password - password of the Application Express Administrator (ex. oracle10gdb)
- tablespace_apex - tablespace to be used by Application Express […]

Outlined below are the possible topics for Oracle Application Express Developer’s Guide Session:

Creating Reports

Generating Reports Using Wizards
Editing Report Attributes
Adding Links in Reports
Saving or Printing Reports in Different Formats

Creating Forms

Creating a Form on a Table With a Report
Creating a Tabular Form
Creating a Master-Detail Form
Editing Form Attributes

Working with Pages […]

Oracle Application Express can be installed in different operating system platforms. Outlined here are the installation requirements in Windows XP environment.
Topics:

Oracle Database Requirement
Browser Requirement
HTTP Server Requirements
Disk Space Requirement
Oracle XML DB Requirement
Oracle Text Requirement
PL/SQL Web Toolkit

Oracle Database Requirement
Oracle database release 9.2 or higher is the required database for Oracle Application Express version 3.0. Oracle Database 10g […]