Annals of Oracle's Improbable Errors
Welcome to Flavio Casetta's official Oracle database application development related blog.
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...
Wednesday, February 26, 2025
Enhanced simple CASE statement syntax in Oracle 23ai
›
Oracle 23ai extends the syntax of the so-called "simple" CASE statement in PL/SQL, that is the version of CASE where an expression...
›
Home
View web version