Annals of Oracle's Improbable Errors

Welcome to Flavio Casetta's official Oracle database application development related blog.

Sunday, September 14, 2025

APEX printer friendly mode - how to enable it ?

If you are wondering why your APEX page is not shown in printer-friendly mode after specifying "Yes" in the relevant parameter of ...

Thursday, September 04, 2025

Item ID (P9999_USERNAME) is not an item defined on the current page.

If you are hitting this weird problem when trying to login to your APEX app running on Oracle ADB 23ai: Item ID (P9999_USERNAME) is not an i...

Tuesday, July 22, 2025

stringify() or to_string() ?

While I was experimenting with genAI LLMs applied to generating PL/SQL code, I noticed that Claude-Sonnet created a function containing a st...

Thursday, June 05, 2025

JSON_OBJECT_T.GET_CLOB(key) returns the string 'null' if the value is null

Discovery of the day on Oracle 19 version EE 19.21.0.0.0: JSON_OBJECT_T.GET_CLOB(key) member function returns a CLOB string containing '...

Monday, May 19, 2025

Ensuring that PL/SQL conditional compilation depending on custom identifiers is based on actual option values

I have a package that in case Oracle APEX is installed, calls a procedure attempting to send a PWA notification and this procedure requires ...

View web version

who is the dude behind this blog?

Byte64
Flavio Casetta

Powered by Blogger.