We are using JSON as data format with RESTful services quite a lot in Oracle APEX. But, purpose of this blog is to see how we can create RESTful services in Oracle APEX which returns JSONP. Problem Statement: When you have your own custom widget which is consuming RESTful web service, and that custom widget …

Here is how you can create cool nested reports in Oracle APEX and jQuery, which looks like below: For this example, I have used DEPT & EMP example where as a nested report it will show all the child records of employee under department record. To start with, first create a new classic report region …

WooCommerce is one of the popular WordPress plugin and is widely used as a eCommerce platform. WooCommerce has provided REST web services to pull and push data.  But objective of this blog is to show you how one can use Webhooks to automatically send new Orders to Oracle Database via APEX ORDS REST web services. This …

How to use global page (page 0) region positions to show them in Wizard Modal Dialog Header and Footer location in Universal Theme? Step 1: Copy existing “Wizard Modal” page template. Step 2: Make following changes in copied template body section Step 3: Make following changes in Display Points in edit template screen. Step 4: …

A blog after many years 🙂 My best practices for PL/SQL are below: Always use Exception Block within each block, function, procedure Send email to your development team for any error which occurs in Production Give top priority to error email Make sure you will never get any error email 🙂 Write reusable procedures/functions and …