If you are reading this blog post you are probably searching for an alternative for the deprecated multimedia (or intermedia) feature of the Oracle Database… and you are in the right post as APEX Media Extension is that replacement!
Just like you, I loved the Oracle Multimedia feature in the Oracle Database. I used the feature in many different applications, mostly related to images. For example, when some students upload images of their work in an Oracle APEX app, or teachers upload images to include in tests, I made thumbnails of the images and resized them so they fit really nicely on the page.
Unfortunately, Oracle announced starting in Oracle Database 18c, Oracle Multimedia is deprecated. You can still use it, but you know it will go away at some point… and that is what happened with Oracle Database 19c. Oracle Multimedia is now desupported and doesn’t even work anymore. The Oracle Multimedia packages are still there, so your code is still compiling and valid, but it’s not doing anything anymore.
Just like you and others, I reviewed and tested different alternatives, but to make a long story short, I wasn’t completely happy with any of them. So we at APEX R&D decided to offer a solution that is easy to use and fully supported. There’s a PL/SQL API so you can use it just like Oracle Multimedia from the Oracle Database. As we love Oracle APEX, we also provide two APEX Plug-ins: one plug-in which sits on top of the PL/SQL API (which is a server-based solution) and another one which is a pure client-side (JavaScript) implementation. Our goal is that it’s as easy as possible to integrate this solution into your Oracle Database and/or APEX app. We named this solution APEX Media Extension and it will be available before the end of the year (2019).
In this initial release, we’ve focussed on converting media, such as:
- resizing images
- cropping images
- adding watermarks to images
- compressing images
- changing image formats (jpg, png, …)
We are eager to hear where else you use Oracle Multimedia!
BUT that is not all… we decided to include this functionality also in APEX Office Print (AOP) (Gold and Enterprise versions)! So, if you already use AOP, in our upcoming version you are fully covered already :)
Interested? Please leave your email on the APEX Media Extension website and you will be first to know when it’s released.
Author: Dimitri Gielis View original post here.
