Logging in PL/SQL that survives ROLLBACK (and 4 mistakes to avoid)
You get a call: last night's batch failed, the transaction rolled back, and now someone asks "what happened?" You open your log table. It's empty. I…
Programming
⚑ Report a ProblemLatest Programming news from Tech News
All topics
AI
agents
ai
api
architecture
automation
backend
beginners
career
database
devchallenge
devops
discuss
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
rust
security
showdev
testing
tutorial
typescript
webdev
Use REST Describe Metadata Before a Payload Contract Drifts
An integration can keep sending syntactically valid JSON after its target contract has changed. The first visible symptom may be a rejected create,…
ORA-00257: The Database Stopped Accepting Writes. The Archiver Is Stuck.
The pager goes off at 3 a.m.: the application is frozen. Every screen that tries to save hangs, and the ones that time out come back with ORA-00257:…
Duplicating a PDB into Another CDB
In Oracle Database 12c , it is possible to use the DUPLICATE command at the PDB level. However, there is a limitation: a new CDB must also be create…
My OCI sandbox factory now installs on a Free Tier account, with no card
Every time I showed people the thing I built — a chat that spins up Oracle Cloud sandboxes and deletes them when their time is up — the reply was th…
Bind Variables: The Hard-Parse Storm That Melts Your Shared Pool
The database is pinned at 90% CPU, the app team swears nothing changed, and AWR is topped by cursor: pin S wait on X and a parse-heavy profile. Nobo…
Oracle SQL: Pseudo-Columns
1. Overview & Core Concepts Definition: A pseudo-column behaves like a table column, but it is not actually stored on disk in the table. Capabil…
How to Build an Antigravity Workflow with the Oracle SQLcl MCP Server and Oracle AI Database
This article adapts the same MCP workflow pattern for Antigravity and Oracle AI Database. Companion notebook:&nbs…
Oracle PL/SQL Exception Handling
An Exception is a PL/SQL runtime error condition triggered during code execution. When an exception is raised, normal execution of the current PL/SQ…
How to read OCI bucket files in OCI Oracle Database SQL using OCI resource principals
How to read Oracle Cloud object storage bucket files using SQL in an OCI Oracle database using OCI resource principals 1. Create dynamic group While…
Oracle Java 27 Release Updates Post-Quantum Cryptography
Oracle announced the official release of Java 27, marking a significant milestone for the programming language. This version introduces critical sec…
From SQL to Conversation: Exploring Oracle Select AI
Introduction What if you could query your Oracle database without writing SQL? Oracle Select AI brings generative AI directly into the database, all…
When Did This Transaction Happen? PostgreSQL Snapshots, LSNs, Oracle SCNs, and More
When did a database change happen? This isn't just academic. Incremental replication must order committed changes and resume exactly without locking…
Open-Source Oracle Database Performance History with PostgreSQL and Grafana
Oracle databases expose a huge amount of performance information through dynamic performance views. The difficult part is not obtaining a metric at…
Oracle Cloud Infrastructure AI Foundations: A Step into the World of AI and Machine Learning
When people hear the term artificial intelligence, they often think of tools that generate text, create images, or answer questions. But artificial…
Oracle Data Redaction: Mask at Read Time, Prove It Isn't Access Control
The support rep sees ****-****-****-0001 on their screen and everyone relaxes. The card number is "masked," the demo looks compliant, the box gets t…
OCI Monitoring Alarms: Six Ways an Alarm Can Look Ready and Still Fail
A practical review of metric timing, query scope, notification delivery, suppression, and operator response While reviewing Oracle's alarm documenta…
OCI - Connecting to an OCI Always Free MySQL DB System: Installing MySQL Shell and Building a "Poor Man's VPN"
%0A%20%20%20%20%20%20%20%20.libutton%20{ %0A%20%20%20%20%20%20%20%20%20%20display:%20flex; %0A%20%20%20%20%20%20%20%20%20%20flex-direction:%20column…
What will happen if Cloud database becomes too expensive ???
For most of the last fifteen years, "move it to the cloud" was the answer to almost every data infrastructure question. Storage was cheap, compute w…
My Experience Running a Homelab on Oracle Cloud’s Free VPS
It’s been a while since I wrote a blog post. Recently, I decided to get back into writing and document something I’ve been playing around with: sett…
Oracle Designer Lost Support in 2013. My AI Agent Develops in It Anyway.
Oracle Designer 10g is a CASE tool from the early 2000s. Support ended in 2013. At my job it is still the center of development: the repository hold…
Following ROWIDs Through an Oracle Unique Index Update
I've always been amazed by how Oracle Database handles updates to a unique column—performing set-based operations that don't violate the unique cons…
Teaching an AI to read a relational database — including Oracle APEX
A few months back I started building a tool to solve a problem that kept annoying me: when you want an AI assistant to help with an old database, yo…
Your First Oracle Autonomous Database on OCI Always Free
The single best way to keep your Oracle skills sharp without a license, a server, or a finance conversation is OCI Always Free . It gives you a real…
"The 6 Pagination Bugs That Eat Oracle Fusion REST API Integrations"
Every collection GET against an Oracle Fusion REST API is paginated whether you ask for it or not. Call GET /workers , treat the response as "all wo…
"Oracle FSCM REST API: What Transfers From HCM and What Doesn't"
If you've integrated with Oracle Fusion HCM ( /hcmRestApi/ ), the Financials and Supply Chain surface ( /fscmRestApi/ ) is 90% the same API with a d…
I built a personal "Agentic OS" that runs my DBA work — with approval gates, audit trails, and a $0.01 morning brief
I'm an Oracle Apps DBA. My whole job is built on one instinct: nothing touches a production system without me knowing exactly what it's about to do.…
Series Week 25 of 52 : API Logging - The Infosec headache of maintaining the logs - The Oracle solution
%0A%20%20%20%20%20%20%20%20.libutton%20{ %0A%20%20%20%20%20%20%20%20%20%20display:%20flex; %0A%20%20%20%20%20%20%20%20%20%20flex-direction:%20column…
ORA-00060 Deadlock: Find It, Fix It, Prevent It
ORA-00060: deadlock detected while waiting for resource is one of the most misunderstood errors Oracle throws. The two myths that cause the most dam…
Oracle Patching, Demystified: CPU, RU, RUR — and What Changed in 2026
Few Oracle topics generate as much confident, contradictory advice as patching. Someone tells you to "apply the CPU," someone else insists you want…