Using 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
