Oracle Database 11g Release 2 Express Edition Available

Oracle Database 11g Release 2 Express Edition (Oracle Database XE) final version is available. It's "an entry-level, small-footprint database based on the Oracle Database 11g Release 2 code base. It's free to develop, deploy, and distribute; fast to download; and simple to administer." Download Documentation Do not forget to check the Open Bugs and Known Issues section.

Oracle APEX 4.1 released and it's documentation

Oracle Application Express 4.1 was released.


"This latest Oracle Application Express release is focused on enhancing existing
functionality and adds data upload capabilities."
- Oracle Press Release

Oracle Application Express 4.1 Documentation Library is also available.

Oracle Application Express 4.1 Early Adopter 2

Encontra-se disponível para testar on-line a versão Oracle Application Express 4.1 Early Adopter 2 em http://tryapexnow.com/

Uma das novas funcionalidades diz respeito à melhoramento no suporte para traduções (em especial as traduções podem agora ser exportadas com a aplicação).

A lista das novas funcionalidade pode ser consultada aqui.

APEX Listener Release 1.1.2 released

APEX Listener Standard Configuration

In May, a new version of APEX Listener was released.
It fixes some bugs like:

• Fixed flexible parameter support to handle POSTs without requiring a query string to be present in the submitted URI.
• Fixed a problem with the standalone Listener where the location of the images folder could not be overwritten.
• Fixed a problem with character encoding when consuming HTML forms submitted using the multipart/form-data content-type.
• Fixed a problem with an IllegalStateException being thrown when the path /apex (instead of /apex/) was accessed on the standalone Listener.

As always you can download the last version at OTN.

APEX Listener Advanced Configuration

APEX 4.1 Early Adopter disponível para testar

Encontra-se disponível para testar on-line a versão Oracle Application Express 4.1 Early Adopter em http://tryapexnow.com/

Já no passado eu tinha postado sobre algumas das features que iriam aparecer na versão 4.1. 
A lista das novas "features" (actualmente implementadas) pode ser encontrada aqui.

As mais importantes a meu ver são: novo controlo para tratamento de erros (Patric Wolf explica em duas partes: aqui e aqui) que permite passar o log de erros para uma função do utilizador; suporte de todos os tipos de validacao nos Tabular Forms; possibilitar a criaação plug-in para autorização (explicado aqui).

Oracle APEX Listener 1.1.1

Oracle APEX Listener 1.1.1 was released last week.

This release fixed several bugs. It addresses the following issues:

Doug McMahon’s Mod_owa updated

The Apache PL/SQL Gateway Module (mod_owa) from Doug McMahon is one alternative for PL/SQL Gateway and was updated last week.

"How APEXBlogs was built" video

Ace Director Dimitri Gielis did a Webinar on "How Dimitri Gielis Built and Launched the New APEX Blogs Website" that was recorded and is now available on video at redgate.
Check it if you miss the Webinar! 

Video about Oracle APEX 4.0 New Features

Oracle APEX 4.0 New Features Training by SkillBuilders.com

How APEXBlogs was built: FREE Webinar

Ace Director Dimitri Gielis will do a FREE Webinar on Wednesday, April 6, 2011 4:00 PM - 5:00 PM GMT : "How Dimitri Gielis Built and Launched the New APEX Blogs Website"

Check here for more info and free registration.

"If you can't make it, but liked to have seen it... register too. The webinar gets recorded and the link will be sent to all registered people, so you can still see it whenever suits you."

update: the recorded video is now available.

Oracle Database 11.2 Express Edition Beta

Oracle released a Beta version of Oracle XE 11.2 :-) (only for windows x32 and Linux x64)

Oracle Database 11g Express Edition (Oracle Database XE) is a free version of the world's most capable relational database. Oracle Database XE is easy to install, easy to manage, and easy to develop with. With Oracle Database XE, you use an intuitive, browser-based interface to administer the database, create tables, views, and other database objects, import, export, and view table data, run queries and SQL scripts, and generate reports.

This version fixes the bugs 10 XE has that were fixed in the standard version and has some new features but doesn't have some cool new features of 11g like PL/SQL Function Result Cache :-(: see Feature availability

Documentation can be found here

Requirements: approximated 0.5 Gb for software installation
Limits: maximum of 11 Gb for user data (it was only 4Gb in the 10g version!). Uses only the equivalent to only one CPU and only 1 Gb RAM.

It ships with APEX installed. update: Attention: According to this posts it ships with a weak default password for APEX_040000 user and APEX Patch 4.0.2 is missing.
Update 26-July: the version I download yesterday for Windows has already APEX Patch 4.0.2 and the user APEX_040000 is locked.

Notice: this version doesn't work with SQL Developer below 3.0 versions. A bug that is promised to be fixed in the final version.

I hope the final version will see the light very soon (maybe for Oracle World?)

Oracle APEX Listener 1.1 available

Oracle APEX Listener 1.1 is available

New feature: "(...)RESTful Application Programming Interfaces (APIs) are created by configuring resource templates. Each resource template is a configuration file that binds a set of Uniform Resource Identifiers (URIs) to a SQL query or anonymous PL/SQL block."

Templates in Oracle APEX video

GogoTraining made the "Template" module of it's online course "Oracle APEX" available.

Free webseminar tomorrow: Audio and Video Management Using PL/SQL

ODTUG is offering FREE Webinars! The next Webinar is tomorrow (February 24th, 2011)!

Free webseminar today: Taking Advantage of Plug-ins in APEX

ODTUG is offering nine FREE Webinars in the next four months! The next Webinar is today (February 22nd, 2011)!

Oracle Learning Library

Oracle Learning Library is an web search index of several free demos and tutorials.
Here are the direct links for the PL/SQL section, the APEX section and the SQL Developer Section.

new Apex patch set (4.0.2.00.07) available

The new available patch set for Oracle Application Express (4.0.2.00.07) is a cumulative patch (that mean that includes the previous patch set release and additional product fixes). It can be applied to Oracle Application Express release 4.0.0.00.46, 4.0.1.00.03 and 4.0.2.00.06


Check the Release notes and the bugs fixed list

Be advised that there is a changed behavior: Row Searches on Interactive Reports No Longer Search for Filter Disabled Columns.

What is planned for Oracle Application Express 4.1

For me the most important issues that are planned for APEX 4.1 are:

• Charting - Provide for chart rendering without using Flash (to enable display on mobile devices).
• Error Handling - Improve error handling and user-defined exception processing.
• Development for Mobile Applications – Include themes and HTML templates suitable for smart phones and mobile devices.
• Interactive Reporting – Allow multiple reports on one page and support pivot queries.
• Tabular Forms – Allow multiple tabular forms on one page and continue to expand tabular forms validations.
• Master-Detail-Detail – Allow the generation of pages to support master-detail-detail relationships.
• Modal Dialogue - Add ability to display a dialog on top of a page (the rest of the page will be grayed out).

Alternatives for PL/SQL Gateway

A attendee of my presentation on OPP 2010 Brussels notice an error in one URL in my presentation and asked me more info in the alternatives for PL/SQL Gateways.
So I provide here my investigation on that (please be free to help me improve this list) with the distintive features of each alternative.

Last day for OPP/APEXposed 2010 in Europe

It's over :-(

Some very interesting sessions and conversations.
All of the attendees tried to get the most of these two days.