Does it happen to you guys to be approached by Java developers and asked to trace some session and then have to track the session and the trace file on the db server? Well, I got tired of being driven away from my things for this and wrote a simple framework that starts the tracing and displays the content of the trace file as an output parameter in the guy’s sql window.
Continue reading…
We encountered today a possible Oracle bug which only occurs in a very specific situation: a subquery returning one row used further in a subcorrelated subquery. Continue reading…
How do you handle custom exceptions in your PL/SQL code? I recently observed the practice of raising an ORA-20001 code with a custom error message every single time and hated it. Why couldn’t we have a documented repository with all these exceptions? Why couldn’t we have some standardized and generic messages to fit to different scenarios? Let’s see a simple solution to obtain that.
Continue reading…
I had an interesting situation today needing to transform two columns – a user id and a list of roles – in rows, each containing a user id and one element from the list (one role id).
Continue reading…
These months my colleagues and I are doing some heavy development for a new version of our main application. I’m talking about tables added or modified daily for 6 different builds and 70 Java and Oracle developers and qa engineers each having around 3 db schemas of his or her own, usually recreated daily. One of the things all these guys and the managers want is to know at any given moment the current state of the tables and relationships in our db, in the 6 official products schemas and in their own 200 schemas. So, instead of torturing a guy from db to regenerate 6 diagrams each day and the developers and qa engineers to regenerate the diagrams for their own schemas, I thought at a way to do this automatically.
Continue reading…
Copyright © 2010–2012. All rights reserved.
RSS Feed. This blog is powered by Wordpress and Modern Clix theme.