A customer had a requirement to invoke a REST web service that is designed to accept a multipart/form-data request body. I could not get it to work with the APEX_WEB_SERVICE API package, so I reverted to using the good old UTL_HTTP package. That package provides the required flexibility when composing a multipart/form-data request. Here’s the code fragment I ended up with and its resulting debug output.
A couple of colleagues and I decided to join ODTUG’s APEX Gaming Competition. The first challenge was to come up with a great idea for an addictive game. We had some creative people sitting around the table and after some brainstorming we ended up with a simple yet interesting concept: a movie guessing game based on a movie database web API.
Now, when you read “movie database”, the first thing you probably think of is IMDb. It came as a surprise to me that they don’t publish an (official) API. IMDb only distributes plain text data files, and that’s not really what we were looking for. In our search for an alternative, we came across TMDb (https://www.themoviedb.org/). It perfectly fitted our needs: an extensive movie database, well documented and reliable.
This post is a quick outline on how to consume a Microsoft SharePoint web service from within the Oracle Database. The SharePoint instance I was dealing with had NTLM authentication enabled. The support for this type of authentication in PL/SQL is pretty much non-existent. The magnificent Alexandria PL/SQL Utilities library, however, includes the NTLM_HTTP_PKG package which does all the heavy lifting for you in this area. I simply installed the Alexandria library in a separate database schema and granted execute privileges to my APEX application’s parsing schema. A great example on how open source initiatives can make a big difference.
The second edition of the Expert Oracle Application Express book is available to purchase since August 13. You can order it from the Apress or Amazon website. The book has been updated for APEX 5.0 and includes 15 chapters, written by 14 different authors. Good for a total of over 620 pages. All revenues of the Expert Oracle Application Express book go to charity. See below a listing of the book’s chapters and their respective writers.
The Liquibase Maven plugin requires us to specify the password of the database schema for which we want to execute a series of database scripts. It seems that the password attribute in the configuration section of the Maven plugin only accepts plain-text passwords. This is absolutely not desirable in enterprise environments. Luckily, we can take advantage of Maven’s standard solution for password encryption, a feature that was introduced in Maven 2.1.0. Follow the six steps below to encrypt the database schema passwords in your POM build files.
Some time ago, I had to give a fundamentals course on the Oracle SQL language. An important topic within that course is the joining of tables. What I was missing in the course book was a clear demonstration on the differences between the traditional Oracle join syntax and the ANSI SQL join syntax. In this blog post, I’ll make a comparison between the two join syntaxes.
Last week I released version 2.5 of the Select2 APEX plugin in which I introduced the lazy loading feature. I also wrote a blog post that described in what way you had to apply lazy loading to a Select2 page item. The technique involved consisted of creating an On Demand AJAX process that then had to be referenced in the Remote Data Process item setting. The bad thing about this Remote Data Process was that you had to duplicate the query from the item’s LOV definition to successfully return the query result in JSON format. It was a solution that worked, but my instincts told me there had to be a better way to incorporate lazy loading in the Select2 APEX plugin. However, I wasn’t able to come up with a better solution.