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)

Oracle 12.1, ORA-01489 result of string concatenation is too long

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: SELECT FNR, ATTEST_DATO, STATUS, TYPE_FORMAAL, LISTAGG(INNHOLD,  CHR(13)||CHR(10) ) … Continue reading Oracle 12.1, ORA-01489 result of string concatenation is too long

Oracle 12.1, ORA-00942: table or view does not exist

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