APEX4 Password Strength Meter Item Plugin

Written by Paulo Vale on Friday, July 16, 2010

I was doing some tests with the new plugin functionality coming with APEX4 and the result is this plugin I'm sharing with you today.


I based the plugin on the "Ajax Password Strength Meter Script" that you can find following this link: http://simplythebest.net/scripts/ajax/ajax_password_strength.html

It's a small plugin using jQuery that provides an easy interactive way to show the strength of a user's password.


Download Oracle Application Express 3.2

Written by Paulo Vale on Saturday, February 28, 2009

The new APEX release 3.2 is finally available for download. This new version covers essentially the Oracle Forms to APEX converter, but also has some extras regarding security.


Download Oracle Application Express 3.2

Oracle Application Express 3.2 Release Notes

Application Express Documentation and Tutorials

Oracle Forms convertion to Apex is here... almost!

Written by Paulo Vale on Thursday, February 12, 2009


Finnaly fresh news... the apex.oracle.com demo server was upgraded to Application Express 3.2.0.00.21. You can't download it yet, but you can test it online. Very soon we'll have a production release available.

You can read all about Oracle Application Express Release 3.2 new features details here.

Additional info on Joel Kallman's post about the new release.

Build an image gallery using APEX

Written by Paulo Vale on Friday, December 19, 2008


This time, I'll show how to build a simple image gallery using Oracle Application Express (APEX) and taking advantage of Jquery framework capabilities. But first of all, follow the link to see the magic happening ;)

There are several slideshow or gallery plugins for Jquery. You can choose the one you like more and re-adapt the code to fit the plugin requirements. My choice was Pikachoose.

Pikachoose is a lightweight Jquery plugin that allows easy presentation of photos with options for slideshows, navigation buttons, and auto play.



Lets begin creating a simple database structure to store the images.

Create a sequence to be used by image id:



Create a table to store the images:



Now on APEX, following the wizard, create a data entry form based on "GAL_IMAGES" table.


Go to Shared Components>Application Items and Create an Application Item. Ex: G_IMAGE_ID.

Create an Application Process to retrieve the image from the database. Identify the point at which this process will run as "On Demand". The point of "On Demand" is that it will only fire when requested by a page process.



Now create the page where you want to put the image gallery and then, Edit Page > HTML Header:




On the same page, create a PL/SQL Dynamic Content region:



And run...

Timepicker and APEX

Written by Paulo Vale on Tuesday, November 18, 2008

ClockPick is a jQuery time picker plugin. As I showed in previous posts, it's fairly easy to integrate third party javascript components with APEX.



A demo of ClockPick working with APEX can be found here.

How to do it?

1- Upload files to your APEX server. You can upload them directly to the server filesystem or use static files in Shared Components;

jquery.clockpick.1.2.4.js
clockpick.1.2.4.css
jquery-1.2.6.min.js

2- Include reference to the CSS file and ClockPick plugin JS file on the page template between HEADER tags or directly in you page properties, Header section:




3- Include reference to the JQuery library file (again in page template or page header):



4- Now the script to make it all happen. Note that this function is binding P9_TIME text element. You can reference the many items you want. You can also change the hour range to be displayed and execute a function after the selection is done. Read ClockPick website to get detailed information about all the configurations available.

ORA-01403 when viewing BLOB data in a report (APEX)

Written by Paulo Vale on Friday, October 31, 2008

This post is almost a note to myself but I hope to help others when you Google for this little problem.

One of the features introduced with Oracle Apex 3.1 is the Declarative BLOB support. About this subject there is already a good article on Oracle By Example (OBE) site: Defining and Viewing BLOB Data in Oracle Application Express 3.1.

Last Friday I lost almost an hour just to have a simple classic report with an image column. I was getting a ORA-01403 error because simply I wasn't referencing the Table Primary Key in my SQL Query!



These are the steps needed to have the image column successfully displayed:

Report Source Query
Important Tip: You must include the Primary Key column in your query.



Report Column Attributes


Format Mask Attributes
Important Tip: Database table and column names are case sensitive.

Tabular Form Element
Include the reference to the Schema, Table and Blob Column.

Oracle Develop 2008 Hands On Labs

Written by Paulo Vale on Friday, October 31, 2008

In case you have missed Oracle Open World 2008 and specifically the Oracle Develop Hands On Labs, this post is for you.

The Oracle by Example (OBE) is a site that provides hands-on, step-by-step instructions on how to implement various technology solutions to business problems. The tutorials presented at Oracle Develop 2008 Hands On Labs, part of Oracle OpenWorld 2008 are now available at OBE site.

Related to Oracle Application Express there are some interesting topics deserving some attention. Some tutorials are basic skills level but you will also find some advanced tutorials. I'm sure we can all learn something with them and that's why I made this list.


Under the topic "Extending the Oracle Application Express Framework with Web 2.0" you will find two excellent tutorials on how to incorporate JavaScript and AJAX into your Apex applications:

Incorporating JavaScript into your Application
Summary:
- Change the value of form elements
- Create client-side JavaScript validation
- Enable and disable form elements
- Hide and show form elements

Using AJAX into your Application
Summary:
- Add a dependent select list
- Set multiple items based on another item
- Add rollover item help


The topic "Creating High Fidelity PDF Reports with Oracle Application Express" takes Apex reporting to another level integrating Oracle BI Publisher functionalities:

Creating a PDF Report with Multiple Queries
Summary:
- Create a report query with multiple queries
- Create a report layout using Oracle BI Publisher Desktop
- Invoke a report from an application page

Including Dynamic Images in Your Report

Summary:
- Add and load a BLOB column
- Create a function that performs the BLOB to CLOB based 64 encoded format conversion
- Create a report query and layout
- Invoke the report from an application page

Storing and Accessing Reports in the Database
Summary:
- Create a table to store your reports
- Generate and store a report in the database
- Access the stored report in the database

Creating Reports With Dynamic Layout Selection
Summary:
- Produce multiple report layouts
- Create selection criteria items and processes for report generation
- Run a report dynamically


The topic "Maximizing the Capabilities of Oracle Application Express - Interactive Reports" is like a showcase on using and manipulating Interactive Reports in Oracle Application Express 3.1:

Using Interactive Report Regions
Summary
- View a record in your report
- Search for information in your report
- Manipulate the interactive report using the actions menu
- Manipulate the interactive report using column headers

Building and Customizing an Interactive Report
Summary
- Create an Application with an interactive report
- Manipulate and customize your interactive report

Utilizing Advanced Interactive Report Region Techniques
Summary
- Reset your Interactive Report Manually
- Create a declarative filter
- Create a derived predefined filter


The topic "Building a Functional Application Using Oracle Application Express 3.1" is appropriated to beginners and will show how you can rapidly create an application using Oracle Application Express:

Manipulating Database Objects
Summary
- Create a table
- Modify a table

Creating and Running an Application
Summary
- Create an application
- Edit Application Objects
- Create List of Values (LOVs)

Adding Additional Components to your Existing Application
Summary
- Add and modify a report, form, chart, and calendar
- Create LOVs and validation items
- Apply a new theme
- Update a navigation list

Adding Security to your Application

Summary
- Create a user
- Limit access to a user


Other interesting subjects, not directly about Apex, but somehow related and not to be missed:


Migrate Your Third-party Database to Oracle Database 11g Today
Migrating a Microsoft Access Database to Oracle Database 11g
Migrating a Microsoft SQL Server Database to Oracle Database 11g
Migrating a Sybase Database to Oracle Database 11g

Managing Your Database with Oracle SQL Developer
Managing your Database with Oracle SQL Developer - An Overview
Oracle SQL Developer 1.5 New Features
 

Source Code Control and User-defined Extensions in Oracle SQL Developer
Using Source Code Control in Oracle SQL Developer
Creating User-defined Extensions in Oracle SQL Developer

One year blogging

Written by Paulo Vale on Sunday, September 21, 2008

Yes, that is right. This blog is one year old.

I thank all of you out there for coming around, reading what I want to say about APEX. Thanks a ton. I hope you will stick with me for the next year too.

Top 10 of most visited posts:

Check all checkboxes
Javascript Calendar Integration
Colorful web forms
Javascript Tooltip Integration
Substitution string and SQL Developer
Populate date field using javascript
Nice filter region template
Translating internal messages used by APEX
Turn Report into PPR Report
A real live APEX application

Most commented posts:

Javascript Tootip Integration
A real live APEX application
Navigate to previous page

Get server URL in Apex

Written by Paulo Vale on Monday, September 08, 2008

Some time ago, I had this requirement to send to the application end users, links to specific pages passing some parameters.

The problem was obtaining the full URL including the server's name and port where APEX was running.

The OWA_UTIL package contains utility subprograms for getting the value of environment variables. Specifically the OWA_UTIL.GET_CGI_ENV function returns the value of CGI environment variables, like REQUEST_PROTOCOL, HTTP_HOST, SERVER_PORT and SCRIPT_NAME, this last one to get the mod_plsql cartridge and the database access descriptor name.

Usage:



You can quickly test these values creating a PL/SQL Dynamic Content region like this:



Now to complete the URL you just need to append the well known f function with the right values. In case you have forget, here is the Apex f function URL Syntax:

Back to real life

Written by Paulo Vale on Monday, September 01, 2008

After 15 well deserved :) days of vacations in the sunny Algarve (south Portugal) I'm back to work. It is hard when I think that just two days ago I was at those wonderful beaches, eating fresh sea fish...

However, not everything went fine :( I just had one of the major sports disillusion, provoked by a bad referee decision.

I've just noticed that while I was away some things happened in the APEX world,  starting with the release of APEX 3.1.2 patch. Judging by the number of fixed bugs I think it is worthy to apply the patch. There are already reports saying everything went fine applying the patch.

A new version of OTN forums came out (again) but unfortunately there are still some problems. Fortunately there are people who can help us deal with some issues like the look and feel.

Me at Oracle OpenWorld 2008

Written by Paulo Vale on Monday, August 11, 2008

It is my first time at Oracle's big event, the OpenWorld. David Peake was kind enough to invite me to participate in one of the official sessions.

So, if you want to meet me, you can find me at San Francisco next September :)

Here is the session description, don't forget to register:



Session Id: S300458

Title
Building Commercial Software-as-a-Service Applications with Oracle Application Express

Date: 24-SEP-08
Start Time: 17:00
End Time: 18:00

Location: Rm 304, Moscone South

Description:
There is a huge buzz around software as a service (SaaS). Come to this roundtable to hear from a collection of companies (from small to very large) that have successfully deployed commercial SaaS applications with Oracle Application Express. The discussion delves into development, deployment, support, and other issues encountered in building these assorted commercial applications. So if you have ever had a brilliant business idea and want to know how to make it into a commercial reality, this session is a must.

Speakers:
David Peake, Oracle;
Paulo Vale, Neoface;
Francis Mignault, INSUM;
Jim Brull, Centroid;
Doug Gault, Hotsos;
Dennis Vanill, Paetec

More APEX sessions at Oracle OpenWorld 2008

Written by Paulo Vale on Monday, July 21, 2008

According to Oracle OpenWorld Blog, the top 25 voted sessions at Oracle Mix will be presented at Oracle OpenWorld 2008. Among the 25 winners there is a good representation of APEX, meaning that APEX community is very active. The winners, APEX related are:

Rank: 1 (113 votes)
Security: Writing Custom Authentication Schemes for Oracle Application Express (Oracle APEX). 
Submitted by: Raj Mattamal

Rank: 5 (90 votes)
How to Hack an Oracle Application Express Application. 
Submitted by: Anton Nielsen

Rank: 6 (87 votes)
Successfully Developing and Integrating Applications in Oracle APEX Within Oracle E-Business Suite.
Submitted by: Haseeb M

Rank: 12 (75 votes)
(Re)Developing a Logistic Application in Oracle APEX in the Real World. 
Submitted by: Roel Hartman

Rank: 16 (68 votes)
Oracle APEX Team Development: Best Practices, Collaboration, and Application Deployment. 
Submitted by: Priya Lapham

Rank: 18 (66 votes)
Rapid Development and Validation of Oracle APEX Applications at an FDA-Regulated Medical Device Company. 
Submitted by: Deb Groskreutz

Rank: 21 (61 votes)
Using Oracle APEX to Analyze Your PL/SQL Source Code.
Submitted by: Flavio Casetta

What I miss the most in interactive reports

Written by Paulo Vale on Monday, July 21, 2008

I'm obliged to say that the Interactive Report Regions is one of the best features in APEX. The possibilities are huge. It's like passing the power to the end users.



A few days ago, I've posted about IRR having an upgrade in the next APEX release. The feature is being called as websheets. The possibility of having a tabular form with inline edit combined with the actual IRR features it's a "just can't wait" functionality.



Still, Interactive Reports are not perfect :) There are some functionalities I miss from the classic reports. I know that I can still use the classic reports, and I do use them many times, but having the possibility I tend to use the IRR as much as I can.



One of the functionalities I miss the most from classic reports is the possibility of being based on a function returning a query. This adds the possibility of a report being dynamically based on different tables or views and having dynamic where clauses. One of the situations where this is very useful is if you want to build a report wizard system in your application.







Also important, would be the possibility to have control over the report template and CSS, something similar to what we have in APEX classic reports.

APEX web form based on procedure using out parameter

Written by Paulo Vale on Friday, June 20, 2008

When creating a form region on APEX, there are several options to base the form such as a table, a view, a webservice or... a stored procedure.

Creating a form based on a stored procedure can be very useful to execute database manipulation operations in a simple way. In fact, it is even possible to obtain responses from the database directly to an APEX page using OUT parameters.

To illustrate this, here is a simple example. Let's say you want to build a form where a user is asked to guess a number. The page should also inform the user if the guessing is right or wrong.

First of all let's create the procedure. Note that there are two parameters on this procedure. p_guess (IN parameter) is used to send the value and p_result (OUT parameter) is used to receive the procedure response.



Now to create the form, create a new page or region. Next choose "Form", "Form on a Procedure", identify the database schema and enter the stored procedure name. Follow the form wizard creation till the end entering adequate values.


After you run the page you will be presented with two fields. Enter a value into "P_Guess" and press submit button to get a response into "P_Result".


Now to beautify the form you can hidde the result field and integrate the response message into the notification template. If you go to page edit mode you will see the auto-generated "Run Stored Procedure" after submit process. Edit this process, click "Messages" and put the reference to the item "Process Success Message" like this: &P6_RESULT.


Follow the link to run this example: http://apex.oracle.com/pls/otn/f?p=25110:6

APEX websheets!

Written by Paulo Vale on Tuesday, June 17, 2008

Just came across this blog post on Dimitri Gielis's Blog and I just can say.... well, just follow the link and see for yourself. Web 2.0 features out of the box, tabular form with inline Edit and much much more.


The screenshot was stolen from Dimitri Gielis's Blog.

Change default Date Picker Icon

Written by Paulo Vale on Tuesday, May 27, 2008

So you don't like de default Date Picker icon? The good news is that there a very simply way to change it.


First of all, you need to have a nice icon. I suggest this website where you can find a lot of beautiful and free icons. Now that you have the icon file you need to upload it to your system. If you don't want to upload to the filesystem, you may follow this path "Shared Components>Images>Create Image" and upload it to APEX static files.

Now to set your icon as Date Picker default you need to update your application Theme. Go to the Themes option on Shared Components and edit the default theme. Then, click "Calendar Icon Details" and enter the path to the uploaded image file.




Change the request of a select list with submit

Written by Paulo Vale on Monday, May 26, 2008

Today I had this requirement with a Select List with Submit in a new application I'm developing. I had a form with an Automatic Row Processing (DML), After Submit process. This process is used only for updates and should be triggered when the value of a Select List changes.


I've created the Select List with Submit but the process was not executed. The reason is that by default the request value is the name of the Select List item and as you can see in the previous picture, the data manipulation process will perform a SQL UPDATE only when the request value is one of the listed values (SAVE, APPLY CHANGES, UPDATE, UPDATE ROW, CHANGE, APPLY, APPLY%CHANGES%, GET_NEXT%, GET_PREV%).

To get around this, here is what I did: first I've
changed the item back to a normal Select List and then added the following code to the 'Element > HTML Form Element Attributes' property:

onchange="doSubmit('UPDATE');"
Here is a screenshot of the Select List item properties:


Happy programming :)

Oracle Application Express 3.1.1 patch set was released

Written by Paulo Vale on Thursday, May 22, 2008

Yes it's true, the patch is out. I found it reading Joel Kallman blog. As Joel states in his blog, this not a new APEX version... it is a patch with bug fixes.

One of the things that makes me happy with our decision at Neoface of directing all the development efforts to this technology (APEX) is the frequent updates APEX team is giving us.

They are doing a great job.

Nice filter region template

Written by Paulo Vale on Wednesday, April 23, 2008

One of the good things that Oracle APEX Team made to help the new developers are the Packaged Applications. Packaged Applications are working example applications that you can use to get the feel of APEX capabilities. You can also learn how things get done, since you can access all the source.

This leads me to the point of this post. I like v
ery much the way, reports filters and options are organized in these example applications. The person who made this, certainly has a good taste :)

Look at the next screenshot to see what I mean. I'm talking about that gray region where the search field and conditions are.


Since I liked it so much, I've decided to use it in my applications. For instance, I've integrated this region template in our APEX built CRM App (Better.CRM).


How to do it? :) Just copy the code from any of the Packaged Applications and then:

- Shared Components > Templates > Create
- Template Type: Region
- Create Region Template: From Scratch
- Name: Finder Bar
- Template Class: Button Region Without Title
- Template Code:


Now you just need to create an HTML Region in your page, apply the new Finder Template and include the fields in the region.

That's it. I hope this helps you make good looking apps :)

New blog

Written by Paulo Vale on Saturday, April 05, 2008

I would like to point you to a new APEX related blog. João Oliveira is my personal friend, works with me at Neoface and he is an experienced Oracle DBA.


APEX is not an exclusive subject, but you will find on beyondoracle blog many interesting topics regarding this technology, specialy in terms of server configurations, security and tunning.

He started his blog last February, so please give him a visit and a warm welcome.