Oracle

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 →

Learn how to accelerate the development process by using the new Session Overrides APEX feature and one of the Visual Studio Code extensions.

See how I combined the APEX Geocoded Address item, several map layers, GeoJSON, SDO_UTIL and SDO_GEOMETRY packages to find nearest stadiums around

Comparing the APEX built-in Geocoded Address item with third party APIs for getting the best search results.

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 →

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 →

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 →

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) →

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) →

It happens that you forget your master ADMIN password for the apex_admin page. Here are the two widely user methods to change it and unlock the Admin account: Use @apxchpwd.sql script in your APEX directory. To run it, navigate to the directory through bash or Command prompt. Connect to your database as SYS and run … Continue reading Unlock APEX Admin account →

It happens relatively rarely to have an error PLS-00907 (PLS-00907: Can not load library unit). We have encountered it few times in our APEX applications. Here is the way to resolve it (performed by a SYS user). Solution : Ask your DB admin to flush the shared pool 🙂

Oracle MIN() Over function has an interesting options. It can be used to get the MIN value from a particular subset of data, or show he MIN value, based on the records ranked so far, if it is used with ORDER BY clause. Here is an example: 1 select ename, 2 deptno, 3 sal, 4 … Continue reading Oracle MIN() OVER function →

Listagg is a great way to concatenate strings in Oracle 12. I have used it in many cases, but sometimes it is just not good enough for a very large strings. Here is the way you can use it for strings, that would not exceed 4000 chars: Here is what can be used if concatenated … Continue reading Oracle 12.1, ORA-01489 result of string concatenation is too long →

This is a bug in Oracle 12.1. When you have a table in one schema (Schema1) with a sequence on some column and you want to insert in that table from another schema (Schema2), error message “ORA-00942: table or view does not exist” is displayed. This happens although you have privileges to select, insert, update … Continue reading Oracle 12.1, ORA-00942: table or view does not exist →