A glimpse of the APEX 22.2 new features – Device Geolocation

Visit my DEMO PAGE and see the new Device Geolocation feature in action. 🌐 Device Geolocation Get Current Position Dynamic Action The new Get Current Position dynamic action fetches the device current location and returns a JavaScript GeoJSON object or Latitude and Longitude to page items, or the full Geolocation object to a custom JavaScript … Continue reading A glimpse of the APEX 22.2 new features – Device Geolocation

Speed up your APEX development using Session Overrides and VS Code

Learn how to accelerate the development process by using the new Session Overrides APEX feature and one of the Visual Studio Code extensions. What is Session Overrides Session Overrides are a convenient way for developers to quickly change values in the session that the APEX engine is typically responsible for, like File Paths, Additional Files … Continue reading Speed up your APEX development using Session Overrides and VS Code

How to find nearest stadiums using Oracle APEX maps and geolocation

See how I combined the APEX Geocoded Address item, several map layers, GeoJSON, SDO_UTIL and SDO_GEOMETRY packages to find nearest stadiums around The use case In this article, I will show you a solution for a situation that I often have while travelling abroad - finding the nearest stadium around me to watch some sports … Continue reading How to find nearest stadiums using Oracle APEX maps and geolocation

Getting the best address and location searches in Oracle APEX

Comparing the APEX built-in Geocoded Address item with third party APIs for getting the best search results. Geocoding and Reverse Geocoding - what is that? Geocoding is the process of taking an address or location and converting it to latitude and longitude geographic coordinates. Reverse Geocoding is the opposite - the process that takes a … Continue reading Getting the best address and location searches in Oracle APEX

Understanding better the APEX Map Region

Learn more about the different Layer Types and Geometry Data Types used in the Maps region and why it's important to know them all Why do you need to read this post? Having knowledge of the different types that represent a geometry can give you the opportunity to visualise more and highly complex geometries on … Continue reading Understanding better the APEX Map Region

Generating Documentation out of your PL/SQL packages

One of the things, often overlooked and missed in projects is good documentation. Benefits of having such are obvious, but many times developers simply skip it, because of the lack of time or managing multiple projects at a time. That's why I think that documenting should go along with the development and be a continuous … Continue reading Generating Documentation out of your PL/SQL packages

SQL Developer fix for MacBook with macOS Monterey

This article is aimed at people, using MacBook (with M1 ARM chips and macOS Monterey). The new 2021 MacBooks come with this macOS – Monterey, already pre-installed. The problem is probably affecting those machines using Intel processors (and macOS Monterey) too, but I can't confirm, since my setup is on a machine with M1 Pro … Continue reading SQL Developer fix for MacBook with macOS Monterey

ORDS, APEX and secure REST APIs (Part 2 – call the API)

Part 2: Accessing your secure REST API In Part 1 of the "ORDS, APEX and secure REST APIs" blog post, we looked at the ways you can secure your REST modules. Now that we have secured the API, let's look at the ways you could access it. There are different implementations and different tools in … Continue reading ORDS, APEX and secure REST APIs (Part 2 – call the API)

ORDS, APEX and secure REST APIs (Part 1 – secure the API)

Part 1: Securing your REST API Some time ago we created a simple REST API using APEX RESTful Services to serve us for some reports. I wouldn't go into details on how to create such, as there are many sources out there describing how to create a REST service in APEX. You could take a … Continue reading ORDS, APEX and secure REST APIs (Part 1 – secure the API)