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...)
It is still a long time before Kscope15. But if I look at the website
.... I can hardly wait!
A good conference needs a good time for preparation. An awesome conference .... needs even more time. So that's why we need your abstracts a.s.a.p. After the close every member of the review committee will go over every abstract and will give it a rating and a comment. When that's all done, the (more...)
the meetups are more or less global nowadays!
And even in The Netherlands we will officially join this virtual group and have our first ORCLAPEX Meetup on Thursday September 18. The location is central and well known: The Dutch Oracle HQ alongside the A2 highway. (more...)
The last two weeks I wrote a daily blogpost about a new feature in APEX 5. And intentionally I didn't cover the "big" features, like the new Page Designer, the Modal Pages, the Universal Theme etc as these probably are - or will be - covered by other people. So in my 10 blogposts I covered "Ten Tiny Things
For those who missed it - all or parts of it - herewith (more...)
To get a proper list of the new packages and API's APEX 5 provides us, we have to wait for the documentation of course. But if you're impatient and want to now more, you can get a list of all package procedures and functions by running this SQL on the APEX 5 Early Adopter instance:
select distinct s.synonym_name, p.procedure_name
from all_procedures p join all_synonyms s on p.object_name = s.table_name
Oracle Openworld 2014 is just around the corner (it’s still not too late to register) and I’m going to be presenting a couple of sessions -
- Oracle Application Express + Node.JS: A Primer [UGF5222] - Sunday, Sep 28, 2:30 PM – 3:15 PM - Moscone South – 300
- Testing Oracle Application Express: Removing the Boring from Testing [CON5219] – Thursday, Oct 2, 2:30 PM – 3:15PM - Moscone South – 303
I presented these sessions (more...)
In APEX 4 you can define Authorization Schemes. This is a very useful feature to prevent code repetition all over the place. For instance and Authorization Scheme "Is Admin" might use a select on one or more tables (or web service calls or whatever is necessary) to determine whether a user, the :APP_USER, has an Admin role or not. And you can use any value in session state, like :APP_ID or :APP_PAGE_ID in your query (more...)
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.
Mein diesjähriger DOAG Vortrag ist am letzten Konferenz-Tag 20.11.2014 um 9:00 (Raum Istanbul)Link: http://www.doag.org/konferenz/vortrag_details.php?locS=0&kid=459293&tag=3&id=484637Auf was könnt Ihr euch freuen?
Ich zeige einen Lösungsansatz mit dem man Grafiken dynamisch nutzen kann, ohne viel Programmieraufwand zu investieren.Beispiel:
Hafen mit dynamisch erstellten Booten und erweiterten Informationen.
In der Präsentation, die wieder eine APEX Anwendung sein wird, werde ich auf unterschiedlichste Beispiele eingehen und den Code im Detail erläutern.
Also sehen uns auf der DOAG!
Over the last months different Oracle Application Express (APEX) meetups
were initiated around the world. You can read a bit of background on how the meetups started on Dan's blog
I think it's a great idea to have local meetups to meet other people working or interesting in APEX too. When you just start with APEX it's interesting to talk to other people how they got started. But equally for more seasoned developers it's a (more...)
In APEX 4.x the developer could implement a feature that involves a call to the APEX API. E.g. you could create new pages on the fly if you would like to (just examine an export file for the how-to). You could drop an application using a procedure from the APEX_INSTANCE_ADMIN
package. You could drop a user using APEX_UTIL.REMOVE_USER
. If this is all on purpose and secured than that's fine. But maybe you (more...)
Now and then it happens when we're logging in into our APEX instance: We have to change our password again .... And that means, typing it in an awful number of times:
1. Current Password
2. New Password (and of course preferably the same as the current one ...)
3. Confirm New Password
4. Press Apply Changes
5. Press Retun
6. And we're back at Square One : The login screen - and here we type (more...)
As a lot of the new APEX 5 features are "by developers for developers
", this one is also a nifty little thing that make our lives easier. Only the developer part of our lives of course....
In the upper right corner of APEX 5 you'll see your login name and a rather anonymous avatar. Just for fun - and recognisability - you can add your own face there. Or a picture of your (more...)
Oracle Open World 2014 starts in just over 4 weeks from now. And I am one of the (50,000?) lucky people who will be there ....
I will even take part in three sessions, one straight at the start and one almost at the end:
What Are They Thinking? With Oracle Application Express and Oracle Data Miner [UGF2861]
Sunday, Sep 28, 9:00 AM - 9:45 AM - Moscone South - 304Panel Discussion: Bring Your (more...)
In the current version of Oracle Application Express you could use up to three items in a Column Link.
Most of the times that is enough. But there were always some use cases where you needed four or even five. And of course, just like with all limitations, you can figure out a work around. But wouldn't it be just awesome if APEX offers us more items out of the box.
In the current version of APEX the Supporting Objects feature is undervalued. You can create (sort of) self installing applications with it, but it is not widely used. Why? Because people don't realy know the feature or people do and experience lack of functionality. In both cases : Check out the functionality of APEX 5!
When you have scripts for creating tables, packages etc., in the current version you have to manually keep those (more...)
While playing around in the APEX 5 EA2
environment I discovered a few neat little features for Calendar regions.
First of all you can export the data of the calendar - only the data that's currently visible - to four types of format. Especially the iCal format is new and interesting as this is readable by most calendar applications. Right now, in EA2, the PDF option doesn't seem to work yet. And alas, the iCal (more...)
Oracle REST Data Services (ORDS) gives us the capability us to deploy multiple versions of the APEX listeners to a single Glassfish instance. This is great for centralizing resources on a single server in our non-production environments. This short post will show you how quick and painless it is to setup.
Setting up 2 instances (apptest & appdev)
Set up 2 directories and unzip into both (more...)