KScope14

ODTUG_Kscope14

This year, from June 22 - June 26, the best convention in the world, ODTUG’s KScope14 will be held in Seattle, Washington. I am already looking forward to meeting some ‘old’ friends again, creating new friends and seeing some of the best content by presenters from all over the world.

Some of the presentations I am looking forward to:

In the Developer’s Toolkit track:

New publication for Oracle professionals

OTech Magazine Winter 2014If you are working with Oracle software as a developer, DBA or application server administrator, you should read the new OTech Magazine.

The Winter 2014 issue is almost a book: 136 pages of high-quality technology articles by some of the leading experts in their respective fields.  My contribution is the article “From Requirements to Tool Choice” about how to choose the right Oracle development tools (ADF, APEX, or Forms).

And did I mention it (more...)

APEX 5.0 Early Adopter

The long awaited Early Adopter installation is finally available at http://apexea.oracle.com. You can request a workspace here to play around with the new version. I have just been playing around with it for about an hour an from what I’ve seen it’s a big change to what we’re used to since APEX 4.

Not only has the look an feel changed to flat ApplicationBuilder  ApplicationBuilder, but I think the biggest visible change is (more...)

Random XDB authentication problems with Apex and EPG: problem solved? So it seems.

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. This is the sort of things I hate, because I cannot fully explain why it works the way it does, anyway, here is a short account of what happened: Some time ago I installed Oracle XE 11g on an Oracle Linux VM. Upgraded Apex to 4.2.3 Installed all my applications with little effort if we

human readable URLs in Oracle APEX – Part 3

In the first two parts of this blogpost series we covered the basics and the technique on how to provide nice/friendly/readable URLs for a public APEX Application.

If you haven’t read the other two parts, please go back and read part 1, then read part 2. Done? Ok, lets continue.

Again here the links for two examples: the Sample Database Application which will be used as example in this post and the click-click Website (more...)

human readable URLs in Oracle APEX – Part 2

In the first part of this Blogpost Series we touched some fundamentals and finally listed some options. If you haven’t read it, yet, please do now before continuing here.

The last post ended with me saying I found a way for hrURLs that works with APEX Listener, mod_plsql and EPG.

I haven’t tested the Thoth Gateway, but based on the documentation I’d say it works as well as the mod_plsql way.

Just to be (more...)

Multitenant Self-Service Provisioning – BETA 2 – No emails out for ADMIN user

What did I mean? Actually, I thought how to rename "ADMIN" user?or How to rename "Email Address" on  Multitenant Self-Service Provisioning? Why I interested in it?

I created New Database by using "ADMIN" user.
I didn't get email about credentials (Because no email address for ADMIN user). (more...)

Multitenant Self-Service Provisioning – BETA 2 – Role

Last post, I posted about Oracle Multitenant Self-Service Provisioning - BETA 2 and read more about what changes have been made in this Beta 2 release.
Users with the PDBA role in the Oracle Multitenant Self-Service Provisioning application can only view PDBs that they created or have been made an (more...)

Multitenant Self-Service Provisioning – BETA 2 – Started to play

Got news on tweeter about Multitenant Self-Service Provisioning - BETA 2. It's very interesting. You will find something change. For example On Oracle Multitenant Self Service Provisioning - BETA 1 runs in APEX pdb.
(Downloaded pdbss_1030.zip and installed)
This version, the Oracle Multitenant Self-Service Provisioning application now runs in (more...)

Oracle Application Express (APEX) 4.2.4 is now available for download

Somewhat unexpectedly, at least for me, Joel Kallman announced a new iteration of Apex. Enjoy

hrURL – human readable URLs in Oracle APEX

Searching the APEX Forum for nice URLs is as old as Oracle APEX itself, so far without much luck. There is magic switch that forces APEX to create readable URLs.

As part of preparing my Presentation “Going Public” for Kscope 2014 in Seattle, I investigated the available methods on providing readable URLs and found some good ones.

You can check this public APEX website to see how good URLs can look like: www.click-click. (more...)

APEX Tree based on Pipelined Table Function

Representing hierarchical data in an APEX Tree is fairly straight forward, the wizard to create a tree region assists you with that. But when you need to show data from multiple tables, you will need to provide your own query. In a previous blogpost I have written how to achieve (more...)

Tree with Checkboxes: Save the Data – JS Array to PL/SQL

In two previous blogposts I described a method to transform a regular APEX Tree component to a Tree component with checkboxes. The second blogpost described a way to retrieve the data from the database using JSON and AJAX and check the appropriate checkboxes. In this last part of the series (more...)

Install APEX Packaged Application by Importing its SQL Script

If for some reason, you could not install the APEX packaged application via Application Builder > Packaged Applications interface, you have an option of installing it by importing the SQL script (fxxxx.sql).

In my case, when installing via the Packaged Applications interface, I got the following error:

Screen Shot 2013-10-02 at 12.06.48 PM

While working (more...)

Tree with Checkboxes – Pre-Select Data with JSON

After you have modified the standard APEX tree to a tree with checkboxes (see this blogpost) you will probably need to find a way to load data from the database and show the values previously checked by the user.
In this blogpost I will show you how to load (more...)

Oracle Application Express 4.2.3 is here

In case you didn't read the news somewhere else, the latest and greatest version of Apex (4.2.3) has been made available for download. Patch set notes include a long list of bug fixes. Thanks to Joel Kallman for the timely announcement.

APEX_MAIL package and views quick reference

Always check out the original article at http://www.oraclequirks.com for latest comments, fixes and updates. APEX_MAIL is the API package for sending emails from Oracle Application Express. In order to be able to execute APEX_MAIL procedures and/or check the related views outside of Apex (from SQL Developer or from (more...)

D-I-Y apex_mail_log maintenance and an Apex feature request

A couple of days ago I submitted a feature request via the Apex Feature Request application because I believe that workspace administrators should be given the possibility of purging the apex mail log if they want to (see feature request AG3A). If you agree with my request, you're kindly invited (more...)

APEX: Tree with Checkboxes

The APEX Tree component is based on jsTree which is a jQuery Tree Plugin. However not all functionality is implemented in APEX. Knowing the component on which it is based, we can find the documentation and enhance the Tree in APEX. One of these enhancements is to have checkboxes in (more...)

APEX: Tree Based on Multiple Tables

When you have a table with a hierarchical relation it is very easy to create a Tree component in APEX. Simply write the hierarchical query using START WITH and CONNECT BY and you're good to go. When you have a Master-Detail relation between two tables, and you want to show (more...)