If You Have Oracle Database You Have Oracle Application Express; Use it or Lose it
I’m starting to like Oracle Application Express (APEX) more and more every day.
I have used APEX to build a dashboard to monitor and report on all Oracle E-Business Suite (EBS) interfaces with external systems.
I am currently working on another dashboard for EBS concurrent programs. For that one I used APEX charts. They are really powerful and versatile. Here is a tutorial on how to use them.
The best thing of all, if you know SQL and PL/SQL you’ll be up to speed on APEX in no time.
Oracle recently published the Oracle Application Express statement of direction (SOD). I am very happy to see that Oracle continues to invest in the development and support of APEX and that new versions of APEX will be released annually.
In fact, the next new version will be 4.2 and according to the SOD, this upcoming version is planned to incorporate the following features:
4 Comments | Filed in Oracle | Tags: apexHow to Download BLOB Content as a File Using Oracle Application Express
In a previous article, you learned how to create a simple Oracle Application Express application to store the content of any file into a BLOB column in the database.
In this article, you will learn how to include in a report a file download link to the content stored in a BLOB column. If the BLOB contains an image, you’ll learn how to display it in the report as well. Application Express makes this functionality extremely simple to implement.
Leave a comment | Filed in Oracle | Tags: apexUsing Web Services in Oracle Application Express [video]
Have you utilized SOAP or RESTful Web Services in your Oracle Application Express application? If not, Marcie Young, consulting curriculum developer at Oracle, shows you how. It’s easy and all wizard driven [Docs].
In the following three screencasts, Marcie goes through the steps to create and use a manual SOAP Web Service reference as well as a RESTful Web Service reference with and without a bind variable.
2 Comments | Filed in Oracle | Tags: apex, video, webserviceCreate an Application to Upload Files Using Oracle APEX, In Less Than 10 Minutes (Video)
A BLOB data type stores unstructured binary large objects. A table column with a BLOB data type can be used to store all types of files such a documents, spreadsheets, images and plain text. You can manage BLOB columns by easily adding file upload and download functionality to a form you create using Oracle Application Express (APEX).
APEX includes declarative BLOB support that enables you to declaratively upload files in forms, and download or display files in reports (ittichai wrote about it here).
The following is a screencast to demonstrate:
- how to create a simple APEX application to store the content of any file into a BLOB column and
- how to save the content of that BLOB into a file on the database server.
I recorded the screencast on Windows 7 and Oracle APEX 4.0 that comes pre-installed with Oracle Database Express Edition 11g Release 2.
But first, here is the code that I used in the screencast:
Comments Off | Filed in Oracle | Tags: apex, howto, videoOracle EBS Customization and Extension – OAF vs ADF vs APEX vs Forms »
The E-Business Suite Technology Group recently released a whitepaper: Extending E-Business Suite 12.1.3 using Oracle Application Express. In summary, “This new whitepaper outlines how to extend Oracle E-Business Suite 12.1.3 (and higher) functionality using Oracle Application Express. Recommended architecture and security considerations are discussed in detail.” For some time now EBS customers have used APEX to extend EBS, with the release of this whitepaper the EBS Tech group has acknowledged the growing use of APEX to extend EBS and have provide recommendations and guidelines for integration.Comments Off | Filed in Links, Oracle | Tags: adf, apex, EBS, oaf
What’s this all about some might ask, is Oracle moving to incorporate APEX as part of the standard EBS tech stack? What about OAF? Isn’t Fusion Applications build on ADF, so what’s up? Well when it comes to Oracle EBS extension and customization, OAF is till the top dog, the E-Business Suite Technology Group continues to recommend OAF for EBS extensions.
6 Tips For Making Oracle APEX Run Faster
Joel Kallman lists steps to make apex.oracle.com run faster, like turning on the KeepAlive setting in Oracle HTTP Server, reducing the open window for Web crawlers in robots.txt, replacing a Database Access Descriptor with an httpd.conf rewrite rule and increasing file system caching and memory size. Read the details at Making apex.oracle.com fast (again).
Comments Off | Filed in Oracle, Tips | Tags: apexGet All the Cool New Features of Oracle Application Express 3.0 in Oracle Database XE
If you use Oracle Database 10g Express Edition (Oracle Database XE) you already have Oracle Application Express (Oracle APEX) release 2.1, it’s part of the XE installation. However, in order to use the many new features of the latest release of Oracle APEX, you need to upgrade APEX, within your Oracle Database XE, to version 3.0.1.
Justin Kestelyn, OTN Editor-in-Chief, blogged about this topic a couple of weeks ago. In reply to a question about the licensing fee of APEX, Justin mentioned that “you can develop a production Apex-based app on XE for free, subject to the terms of the XE license”.
A few days ago, I followed the instructions in this document to upgrade APEX within XE on my Windows Vista laptop. The upgrade was very smooth and took about 20 minutes to complete. I also wanted to test Jing, a new and simple screencasting tool, so I recorded the upgrade process as a 5 minute screencast: Continue reading…
4 Comments | Filed in Oracle | Tags: apex
