On Oracle
Wednesday, December 10, 2025
Three Oracle cursor error Tests
›
In this Blog, we will test 3 Oracle cursor errors: ORA-01001: invalid cursor ORA-06511: PL/SQL: cursor already open ORA-21780: Max...
Monday, September 15, 2025
ORA-06502: NULL index table key value and plsql_optimize_level
›
In this Blog, we will show that the logically equivalent Plsql code can have different behaviour when toggling plsql_optimize_level. Note:...
Saturday, September 6, 2025
"ORA-00001: unique constraint violated" Debugging
›
In this Blog, we demonstrate two approaches to debug ORA_00001, one is using errorstack event; another is with DML before trigger. Both are...
Monday, September 1, 2025
Oracle Database Stuck on DB Writer Wait Event: "oradebug request completion"
›
Blog: Perilous New Undocumented Tracing Feature in Oracle 21c oradebug request completion revealed DBWR wait event "or...
Sunday, August 3, 2025
Reading CLOB Line by Line with SQL and Plsql: ChatGPT and Gemini Implementations
›
Following previous Blog: Reading CLOB Line by Line with SQL and Plsql , we will show and test SQL and Plsql implementations provided by C...
‹
›
Home
View web version