Good Blog Bad Blog

Just checked if the http://www.odtug.com/apex is available again and it is. It seems the people there are filtering blogs because I don't see my blog post from yesterday appearing there and I don't understand why. Is that just because I said that the old blog listing was much better? Or this is just another technical problem they have? Am I going to be removed from that blog listing forever if I continue saying (more...)

You shouldn’t think this happens only to you

Since several hours I am getting this while trying to access all blogs at http://www.odtug.com/apex. It seems that this list has a lots of problems listing all the relevant APEX blogs. The previous version from Dimitri was so much better and user friendly.

Value Placeholder

Did you know that you can use Value Placeholder in your page items to display hints for the users? This is a quite neat feature you can implement without using different plugins for displaying hints. It will also work with the APEX ampersand substitution strings like

&P1_ITEM.

Here is how it looks like. Be carefull with this. It will work only for the browsers supporting HTML5.

APEX Connect 8th and 9th of June 2015 in Duesseldorf Germany

APEX Connect is the first big APEX event in Germany and will be taking place in Duesseldorf on 8th and 9th of June 2015. You can still apply for a presentation using this link. I will be there with a presentation on APEX Plugins. As far as I know a couple of international guests are expected to be there as well. This event will for sure be interesting and informative so you should think about (more...)

APEX 5.0 New Features – Terminverschiebung

leider müssen wir den Termin für den bei uns gebuchten Kurs "Oracle APEX 5.0: New Features" (Termin: 08/09.12.2014) auf den Februar 2015 (09.02/10.02) aus gegebenem Anlass verschieben.

Wie Sie/Ihr bereits bestimmt erfahren haben, wird sich das Release von Oracle APEX 5.0 etwas verschieben: https://blogs.oracle.com/apexcommunity_deutsch/de/entry/openworld_update_application_express.

Sie können sich hier zum Kurs anmelden.

XML Parsing Error: no element found Location: …

I am just working on an application which is supposed to be exposed to public users. I created a simple ajax process there which gets a value of an application element and does something based on the value. While calling the on demand process I am getting this error while not authenticated:

XML Parsing Error: no element found Location: moz-nullprincipal:{6492ed13-2b81-4989-938c-7c19121f419a} Line Number 1, Column 1:



After searching for this error in combination with APEX I (more...)

Mein APEX Vortrag bein Orbit in Bonn

Am 05.11.2014 halte ich einen Vortrag über Rapid Application Development bei Orbit in Bonn. Dabei wird auch noch mein Freund und Kollege Tobias Arnhold sein. Er wird über die Themen Plugins und Reporting sprechen. Anschließend zeigt Frank Weyher (der ebenso ein guter Kollege und Freund ist :)), wie man APEX mit Office integrieren kann.

Die Themen sind sicherlich interessant und eine Anmeldung lohnt sich sicherlich. Der Link zu der Veranstaltung finden Sie hier.

APEX – Default Branch on Submit

Yesterday I spent two hours on debugging one of my applications and searching for an answer. Of course, the problem was caused by myself. Here is what happened:

I copied a page and deleted the region including buttons and items using the Cascade to Delete Buttons option.



Then I created a form and had there a process on submit to upload files in my table. Everything was working fine except the fact that after the (more...)

APEX 5.0 New Features Schulung

Unsere nächste Schulung hat APEX 5.0 New Features im Fokus. Diese findet im Dezember am 08. und am 09. in Bensheim statt. Wenn Sie auf diesen Link klicken, können Sie die Details anschauen und sich ggf. anmelden. Dieses Thema is sehr spannend und viele neue Features bzw. Änderungen kommen auf uns zu. Wir denken, dass Dezember der richtige Zeitpunkt dafür ist, damit anzufangen.

Set Focus on Added Row Tabular

This sounds quite simple:

"I would like to set focus on the new added row in my tabular form."

In the following example, you can se how to acomplish that.

Cascading Shuttle – Keep Selected Values

There are probably a several good ways to solve the following problem:

    1. you have a simple select list which cascades a shuttle element
    2. you select something and the shuttle is populated
    3. after that, you pick a value in the shuttle and move it to the rigt side
    4. then you change the select list again
    5. the values you selected in your shuttle are now lost


This example shows how this can (more...)

jQuery – loop through a Tabular Form

This question is one of the frequently asked questions - "How do I loop through a tabular form using a dynamic action?". This example shows how to loop through a tabular form and set the values for each row to what ever you want. Using apex_application.g_fxx array is not an option for onload processes or dynamic actions. It can only be used in an on submit process. Using jQuery in a simple loop (more...)

OTN APEX Forum again

The OTN Forum is not available (again). This usefull but constantly changing forum now gives me the following message:



I am not sure why they are using jive for that. Maybe APEX would be a better solution.

OTN APEX Forum Link

Oracle again changed the layout of the forum. For me, the old link didn't work any more. In case you have problems finding it, here is the new link:

https://community.oracle.com/community/database/developer-tools/application_express

If you go to the forum and search for example for "APEX" or "Application Exp", you will see no results. Typing in "Application Ex" will find "Application Express".



Each of the found links will have a funny description saying:

"An error occurred processing (more...)

APEX 5.0 – Rejoin Session

This great feature is finaly there. I remember asking for a solution back in 2007. I needed to send emails with application links to my users. If they would receive an email they would click on the link and were supposed to land on a particular page. The problem was that they would already have an open session and they expected the link to go straight to the page without asking for a new login. (more...)

APEX 4.2 – Knowhow aus der Praxis

Unser Kurs findet am 26.05.2014 - 28.05.2014 in Bensheim statt. Die Details vom Kurs können hier gefunden werden. Das ist unser letzter Kurs, der sich mit der APEX 4.xx Version befasst. Der nächste Kurs und alle weiteren Kurse werden sich mit der Version 5.xx beschäftigen. Nutzen Sie die Gelegenheit und melden Sie sich an. Unser Gastredner Carsten Czarski wird zwei Themen begleiten:

- Sample Geolocation Showcase
- APEX Mobile

(more...)

OGh APEX Conference

Last week I was presenting at OGh (ORACLE GEBRUIKERSCLUB HOLLAND) APEX World. My topic was "APEX 4.2 Application Deployment and Application Management". I can only recommend this conference to all the APEX users in Europe. This is definitely the biggest APEX conference on our continent. If you don't travel to ODTUG then this is something you shouldn't miss. They have an international track where you can listen to the well known APEX developers and (more...)

APEX 5.0 Page Designer Videos

There is a nice series of videos regarding APEX 5.0 Page Designer on YouTube. You can watch it here. David Peake is showing how the new Page Designer works. It is worth of having look at it and much easier that finding it out yourself. Enjoy.

APEX Plugin Page

I just noticed that http://www.apex-plugin.com is programmed using php and jomla. Shouldn't it use Oracle APEX?

APEX IR Query Plugin

I already posted about the function for getting the IR query here:

http://www.deneskubicek.blogspot.de/2013/05/getting-interactive-report-query.html

Now, I decided to create a dynamic action plugin based on that function. The plugin has been submitted to the plugin directory at http://www.apex-plugin.com/ and should appear there soon. If you want to see how it works and download the code, you can do it here as well: https://apex.oracle.com/pls/apex/f?p=43045:1