Amis Blog

  Tomorrow morning I will travel to San Francisco (well, first to Redwood Shores) for this year’s of Oracle Open World - the largest Oracle party in the world. It is my fourth attendance in a row - and it is going to be the busiest by far. For starters, I am presenting five sessions (don’t [...]

  While looking into the XML functionality in JDeveloper 11g, I came across a feature that was added in the 11.1.1.1.0 release - July 2009: [Create] XML Schema from XML Document. Functionality previously found in commercial products such as XMLSpy, that enables us to make a head start with the development of XML Schema Definitions by using an existing [...]

  A few months ago I came across a relatively new book: Processing XML Documents with Oracle JDeveloper 11g by Deepak Vohra (370 pages, Packt Publishing, ISBN 978-1-847196-66-8, February 2009). It is an interesting mix of topics, all having to do with XML and most directly related to JDeveloper. The topcis and chapters do not at [...]

Its time to enlist. It really is. At least regarding the XMLDB related sessions and presentations during Oracle Open World 2009. As far as I have seen today, the hands-on workshop has almost no seats left and more than half already enlisted for my XMLDB New Features and XMLDB Performance related presentation. Oracle Open World doesn't have much XMLDB related sessions, until now from the 1800+ sessions, I only counted a dozen or so. If you want to have a peak of the ones I found, have a look at the following Oracle OTN XMLDB Forum thread. Oracle Open World 2009: XMLDB Presentations and Related Workshops I enlisted for most, as long as they didn't interfere with my presentation schedule, if not only that I am very anxious about Mark Drake's presentations about Google API mashups etc combined with the XMLDB functionality in the database and the, probably extended version of how to build an APEX content management system based on the versioning and filler capabilities of the XMLDB Repository. During OOW 2008, Carl Backstrom, helped and co-presented this APEX/XMLDB joined venture and, alas, this demo app of the XFILES light weight XMLDB CMS, never (at least yet AFAIK) hit the apex.oracle.com demogrounds or the OTN XMLDB main pages. read more...

  Oracle Database 11g Release 2 introduces the successor to the good old Connect By based hierarchical querying, called Recursive Subquery Factoring. The basics are described in a previous article: http://technology.amis.nl/blog/6104/oracle-rdbms-11gr2-goodbye-connect-by-or-the-end-of-hierarchical-querying-as-we-know-it. This article will show some additional examples of using this recursive subquery factoring syntax. The essence of this recursiveness: the subquery consists of two queries unioned [...]

After installing the Oracle SOA suite 11g, you will notice that you have to enter username and password  for each managed server during startup and shutdown. This in contrary to the administration server where you don’t need to enter username and password at startup. I was wondering if there was an easy way of skipping [...]

 One of the most spectacular new facilities in Release 2 of the Oracle 11g Database is called Edition Based Redefinition - not a name perhaps that suggests any spectacle. EBR (Edition Based Redefinition) is a mechanism that allows on line application upgrade with no planned downtime. In short, the new release is built up in [...]

For "What you always wanted to know, but never dared to ask about Oracle 11g Release 2…", come and attend our technical session on 29th of September during the "AMIS Query – Technical Introduction of Oracle Database 11g Release 2". As said on the (dutch) invite: :"We will be organizing on Tuesday the 29th of September [...]

I got a small request from the UKOUG team if I could be so kind to do a little bit of advertising for the UKOUG conference. The first thing that popped into my "Of course, no problem".  If you didn’t know, at least that my honest opinion, the UKOUG conference is the best big and [...]

This article describes an architectural pattern, implemented in the Oracle SOA Suite 11g, that is somewhat similar to the Oracle Database 11g Function Result Cache. It introduces a SOA Composite Application in the role of Result Cache. In its most simple form, the result cache is initialized - loaded with values -, used by other SOA applications [...]

I have been invited to deliver two talks on performance at the OPP conference, November 10th and 11th in Atlanta. The topics I will address are Pipelined Table Functions and Optimizing SQL with Collections. I will be among some of the best experts in the PL/SQL world, including Steven Feuerstein, Bryn Llewellyn and many others. [...]

You are probably familiar with the FIRST_VALUE and LAST_VALUE analytical functions that were introduced some time ago into the Oracle RDBMS, in the 9iR2 release I believe (or at least that is when they made their way into the Standard Edition). These values are used to find the first respectively last value in a window [...]

  Today we had a little issue with the inputFile component in ADF 11g, especially with its behavior after failed validation. Our situation: the inputFile component has autoSubmit set to true - so immediately after selecting a file in the browser dialog is the upload started in an asynchronous request. Validation is performed, either from validators [...]

  Last week we had some problems with the deployment of our ADF 11g applications on a stand alone WebLogic 11g (10.3.1) server. One of the issues that kept recurring during the deployment was a ClassCastException reffering to the ADFLogger class - that our application did not explicitly use. We got the impression that the ADF libraries [...]

Packages in the Oracle Database are a fine construct to use for creating a service API at PL/SQL level - that through JDBC or other connections into the database can quickly be exposed at other levels than just internally for PL/SQL. A service API has a number of characteristics, that typically include a structured, well [...]

In our series on the 11g R2 release of the Oracle RDBMS, AMIS staff discusses various functions, features an facilities that have been added, improved or extended in this latest release. These articles are the fruit of several months of studying this new release and projecting which new features and changes would be the most [...]

  I occasionally create custom JavaServer Faces components. Just enough to sort of remember what the steps are, but not nearly frequently enough to quickly put a new component together. This article demonstrates the quick step approach to creating a new custom component in the old fashioned way (that means: it is not a Facelets template [...]

  In our series on the 11g R2 release of the Oracle RDBMS, AMIS staff discusses various functions, features an facilities that have been added, improved or extended in this latest release. These articles are the fruit of several months of studying this new release and projecting which new features and changes would be the most [...]

Many years ago, Oracle basically set the standard in SQL. Whatever was Oracle SQL could be seen as the standard. This has never been absolutely true - ANSI SQL was different from Oracle SQL. In some respects the differences can be traced back to lack of functional richness in the standard. However, in certain areas, Oracle [...]

Various scenarios may require sending email messages or other types of notifications to users as part of the process flow. For example, certain types of exceptions that cannot be handled automatically may require manual intervention. For example, a BPEL process can use the notification service to alert users by voice, IM, SMS, or email.  In a [...]