| Blog | https://blog.cloudnueva.com |
| Website | https://www.cloudnueva.com/ords/prod/r/cloudnueva/website/contact |
| Interests | Hiking, Camping, Technology |
| Tech Stack | Oracle DB, APEX, ORDS |
Introduction Developers are taught the DRY (Do not Repeat Yourself) principle. When I write PL/SQL code, I always think of how this code could be re-used in the future. This usually involves breaking large procedures and functions into smaller, more ...
Introduction Oracle REST Data Services (ORDS) is an incredibly versatile tool for building REST APIs on the Oracle Database (and MySQL). Used in conjunction with Oracle Cloud Infrastructure (OCI) services such as API Gateway, you can take your ORDS A...
Introduction I was working on a task recently where I needed to maintain an array of record IDs during a PL/SQL loop. I needed the array so I could mark successfully processed records after the loop was complete. This is pretty easy to do with PL/SQL...
Introduction In this post, I will describe what a Webhook is and show examples of how Oracle REST Data Services (ORDS) can be used to handle Webhook events. I will dive deep into an example of a SendGrid Webhook, summarize three other examples, and f...
Introduction In my previous two posts, I covered sending files to the Oracle Account Reconciliation Cloud Service (ARCS) file system and running jobs in ARCS. In this post, I will complete the series by describing how you can extract data from ARCS o...
Introduction In my previous post, I showed you how to send files to the ARCS file system using Oracle APEX. This is the first step in most inbound integrations to ARCS. In this post, I will show you how to start an ARCS job from APEX and monitor its ...
Introduction In this series of three posts, I will show you how to integrate data with Oracle Cloud EPM Account Reconciliation (ARCS) using Oracle APEX and the available ARCS REST APIs. Part 1 Getting Started and File Handling in ARCS (this post) P...
Introduction For the longest time, as APEX developers, we have had to utilize workarounds to refresh Dynamic Content regions in APEX dynamically. I even wrote a blog post with an approach I use to solve this problem Solving the APEX PL/SQL Dynamic Co...