Annals of Oracle's Improbable Errors

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

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 ...

Friday, March 21, 2025

DBMS_STATS.GATHER_TABLE_STATS fails with ORA-01760 illegal argument for function

This is just a reminder in case I'll stumble upon this problem again in the future. Oracle Database 19c Enterprise Edition Release 19.0....

Wednesday, March 12, 2025

Errors returned by expressions in SQL queries are not necessarily the same as the errors returned by equivalent PL/SQL expressions.

Have you ever noticed that error codes change depending on whether the context is SQL or PL/SQL? DECLARE x number := 0; y number; B...

View web version

who is the dude behind this blog?

Byte64
Flavio Casetta

Powered by Blogger.