Oracle & APEX Geekery

I had some reactions on my post, describing an issue that occurred when using the DHTMLX library in combination with APEX: From Bharadwaz (Bharat) Pappu , Subject: ODTUD- Oracle APEX + DHTMLX integration Hello Christian, The presentation at APEXPOSED will be similar to the one I did at ODTUG. There is one huge change though…Instead of making changes to the .js files or the DHTMLX APIs I use a very powerful DHTMLX API to integrate it  with Oracle APEX. As promised to you earlier here is a snippet of the code that will work without changing any APEX or DHTMLX APIs: <link rel="STYLESHEET" type="text/css" href="/i/javascript/.../dhtmlxSuite/dhtmlxtree/samples/common/style.css"> <link rel="STYLESHEET" type="text/css" href="/i/javascript/.../dhtmlxSuite/dhtmlxtree/codebase/dhtmlxtree.css"> <script...

Oracle Application Express Forms Converter A migration guide using the APEX conversion utility Convert your Oracle Forms application to Oracle APEX successfully by Douwe Pieter van den Bos Packt Publishing 2009 ISBN 1847197760 ISBN 13 978-1-847197-76-4   Douwe Pieter van den Bos’s book “Oracle Application Express Forms Converter” covers all the aspects and tasks of your Forms conversion project, step-by-step, well explained and packed with screenshots. The books tutorial-like organization guides you through the whole conversion process, from planning and preparation, through conversion and customizing your application, to deploying it. If you are thinking of migrating your Oracle Forms and/or Reports to APEX, this book is a “must‑have” on your project teams reading list. Nevertheless, you will need some knowledge of Oracle Forms and APEX to make this an easy read. Instead of going into details, in some cases you will find references to the appro...

Well, another post on browser behavior. Actually it's about an Add-on. This time it's about a bug I ran into using the Firebug (current version: 1.4.3). Firebug is very popular under Apex Developers, so I thought this might interest you. Firebug actually works fine, but if you are using AJAX calls in your Apex application (or any other web application), you will notice that the AJAX call is made, response received, but not processed. I tried all the other browsers, no problems; just Firefox did not behave correctly. I had no idea. A post on Firefox Support Forum ... another week of cluelessness ... finally I got a friendly hint, directing me to this blog-post: Firefox 3.5/Firebug XMLHttpRequest and readystatechange bug " Looks like this problem is caused by Firebug and solved in the upcoming release 1.5 (currently alpha). Update 5-nov-2009: Firebug Add-in update 1.4.4 is available. I installed the update and the mentioned problem does not occur anymore. ...

When developing web applications you sometimes want to develop/test your app with different users (sessions) simultaneously and not logout-login-logout-login every time to switch. When using Internet Explorer, you might have experienced some differences in session management between IE6/7 and IE8. I found this article on MSDN Blogs, which explains the differences and helped me to configure the behavior I wanted.

Apex is using its own syntax to pass URL parameters, called the f?p syntax. In fact, there is only one standard URL search-path parameter: "p". "p" accepts a string build as: App:Page:Session:Request:Debug:ClearCache:itemNames:itemValues:PrinterFriendly I am not going to explain all the individual arguments. They should be familiar to most APEX developers. I would like to discuss the itemNames:itemValues argument pair, which allows us to pass custom parameters to our page calls. When using external libraries, like the "Yahoo! User Interface Library" (YUI) , JQuery or (in my case) DHTMLX , you might find, that the f?p syntax is not always usable with these libraries. In some cases, URL’s get assembled by those libraries dynamically, expecting the standard search-path syntax ( ?P1 =V1 &...&Pn =Vn ). I came across this problem when using the xmlLoad functionality in the DHTMLX library. This method adds an additional par...

  Last week I visited the ODTUG Kaleidoscope 2009 Conference in Monterey, California. Now, that I got over my jetlag and back to work, I'm trying to order and evaluate all the impressions, ideas and inspirations I got during this event. I brought three green flashlight bouncing balls back home for my kids (got them from one of the exhibiting vendors). Of course they had lots of fun test-bouncing these goodies immediately. This is, kind of, what I feel right now: I really would like to start playing around with some of the techniques, tools and frameworks I learned about ("research", as I would describe it to my manager). On second thought, evaluating the information I got, putting it into my work's context and then test driving it seems a better approach to me. Definitely when I saw the devastating effect of the bouncing balls on our livingroom's interior. ADF, APEX, jQuery, REST, SOAP, SOA, jXLS, ... when to use what and where? Still, the technique is n...