Services are useful, especially for tracing

(Picture by Shane Hauser, via Unsplash) A fellow developer recently asked me if I could help him check if a bug had been fixed in production or not, because he could not trace (pun intented) recent changes. The problem consisted in 2 specific queries launched a gazillion times on an Oracle 12.1 database. Among other […]

Read More

Prerequisites to debug PL/SQL in Oracle Database 12c with SQL Developer

(Picture by Nata-Ap [CC BY-SA 3.0], via Pixabay) Why I am so obsessed with ACL ? I have no idea ! Actually it is the other way round, ACL are hunting me. This morning, I helped a fellow developer who wanted to debug his new PL/SQL procedure with SQL Developer. His first attempt generated errors […]

Read More