Generating XML from SQL & PL/SQL and Code Instrumentation

From time to time you’ll have to represent your data stored in a database in an XML format, eg. to exchange it between systems, to send it to external parties, etc.
In an article on All Things Oracle I give an introduction on how you can generate XML documents:

Another interesting article from my colleague Jan Leers is about Code Instrumentation.

Whenever we execute a procedure, it’s out of our hands. We expect it to do what it was designed to do, but what if it doesn’t?
What if it takes a lot more time then expected?
All kind of questions start to arise:

Is it almost finished, should I wait just a few more minutes?

Is it trapped in an infinitive loop? Or are my queries running slow?

Can I safely kill it? Or did it already commit some changes and should I reverse them?

Which job should I kill, is this mine?

Want to find out how you can answer these questions? Read his article on All Things Oracle…