Blog - comments

hi i am also facing the same issue please tell me how u resolved this.

sandeep singh

How you resolved this

sandeep singh
Hi Nag,Thanks for your comment. Do you have a problem when creating the procedure or when executing ...

Yes it is not line with that statement but I didn't write the first quote ;)

Anton Ivanovitch

thank you very much. It was like a walk in the park

Blog Arnaud Berbier Oracle APEX 4.2 HTML 5 item types

dbi services Blog

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
Posted by on in Middleware

Oracle APEX 4.2 HTML 5 item types

In this blog, I will explore the HTML 5 new item type features of Oracle APEX 4.2. The objective is to use the new number, e-mail, phone number and url html 5 item type and the native browser validation capability.

I have created a new database application with the theme 25 which fatures responsive design principles (auto adjusts to the screen dimensions and works well on desktop, tablet and mobile devices).

Nice Themes!


To continue my html 5 item type test, I tried to add a new item on the home page previously created.

I went to the item type selection such as number, e-mail, telephone and URL, but unfortunately, there are not displayed! Where are they?


I’m surprised that all item types are not already supported.

At the bottom of the item type page selection, a drop down list is present to show or not the unsupported item type such as date picker (html5)(unsupported), slider (unsupported).

So in this blog, I tried it. What would be the effect?

I added this new item type which works well and is display correctly. But it's not supported by Oracle, to be used at your own risk. 


On the sample below, date picker and slider use native html5 item type are displayed as wished

Date picker resulting html code is as follows:


Slider resulting html code is as follows:


When I change the values, the value of each html5 type is correctly set.

Let’s have a look at the unsupported item type and see the difference using database application with jQuery Mobile Smartphone User interface and associated themes.

I tried to create a JQuery Mobile database application for testing purposes.

On the homepage, I added a new item and when the selection page of the item type appears, I was suprised that there are other items than the desktop user interface. 


Note that the html5 date picker and slider are supported. Some other item type such as shuttle, text field with autocomplete, list manager, rich text editor, date picker are not supported for this application type.

At this stage, I understand that depending on the context (database desktop and mobile user interface) the supported and unsupported item type are not the same.

For this blog posting, I wanted to use the item type such as native HTML 5 input type number, phone number, e-mail, etc.

To add this new item type, you just have to create a new text field:


These Html 5 types have been categorized as a subtype of the standard text field. It can be set in the properties.

The following picture shows a text field e-mail subtype creation:


On the page rendering, you will find the code generated by the APEX Engine and interpreted by Google Chrome.  


The required code is correctly generated.

So let’s try the native browser user input validation. Surprise! No validation is performed by the browser before submitting the form.

So, unfortunately, and prematurely, this new type is not ready. It is not compliant with the W3C standard and not ready to be validated correctly in this APEX version.

The fact is that the html form attribute has the "novalidate" properties which restrict the HTML 5 items type features.


The "novalidate" attribute specifies that the input form-data should not be validated when submitted and therefore restricts the usage.

Let’s have a quick look on the used template. The #FORM_OPEN# substitution string for all templates is not customizable and is part of the internal APEX engine. The html tag property is not customizable yet.

To conclude, this new release of Oracle APEX 4.2 seems quite pretty with its HTML5 support, but it is not yet usable. 

Tagged in: APEX HTML 5 Middleware
Rate this blog entry:

Arnaud Berbier is Consultant at dbi services. He has more than three years of experience in Oracle application development. He is specialized in PL/SQL and APEX 4 development and masters the programming of requests in SQL language. He has a solid expertise in the analysis of business requirements and architectures based on Oracle technologies. He is Oracle Application Express 4 Developer Certified Expert, Oracle Certified Associate (OCA) WebLogic 11g System Administrator, OCA Java, and ITIL Foundation V3 certified. Arnaud Berbier holds a Bachelor of Science in Information System Management from the University of Applied Sciences Western Switzerland (HES-SO ARC) in Neuchâtel. His branch-related experience covers Public Sector, Financial Services / Banking, etc.


  • No comments made yet. Be the first to submit a comment

Leave your comment

Guest Saturday, 04 July 2015
AddThis Social Bookmark Button
Deutsch (DE-CH-AT)   French (Fr)


Contact us now!

Send us your request!

Our workshops

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

Expert insight from insiders!

Fixed Price Services

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

A safe investment: our IT services at fixed prices!

Your flexible SLA

dbi FlexService SLA - ISO 20000 certified.

dbi FlexService SLA ISO 20000

ISO 20000 certified & freely customizable!

dbi services Newsletter