Several times during my career, I have encountered the need or the question of how to run operating systems commands from the Oracle Database. Doing research on the topic – there are two main ways to accomplish this task. Java or DBMS_SCHEDULER Java Once Oracle included JAVA in the database (v8 + review the version […]
I run a lot of VM instances of Oracle. Some are to test different installations and versions of Oracle, APEX, APEX Listener, ORDS, etc. It is very frustrating to fire one up and then get faced with the dreaded 400 error from the Oracle connection. Then I have to remember which standard (of several) I […]
I had a requirement today to use the Saved Reports feature of APEX to create a list of reports for users to pick from. The issue was with the default report name. We wanted the name to reflect what the report was designed for. Showing a label of “All Data” was mare appropriate for the […]
Disclaimer: These notes were written in November 2015. The services described here may change rapidly based on Amazon offerings. Please verify with Amazon as some of this information may have changed. Recently I have had the opportunity to test and learn a little about the Amazon web services (AWS) Relational Database Service (RDS) offering. RDS […]
In my recent travels, I have encountered some individuals who ask what I do. I have been working on my elevator pitch, and it is harder than I imagined. When I mention that I have a long history with Oracle APEX, I am often greeted with the question…. Q: What is Oracle Application Express (APEX)? Short […]
Example Application and Presentation from KSCOPE 14 about APEX cookies and automatic authentication.
CLOBS, BLOBS, LOBS – Dealing with attachments in APEX
Presentation and Sample Application now available!