Posts

PLS_INTEGER... I don't think so!

Once got called to a meeting where an engineer was going to teach us some revolutionary techniques of programming in PLSQL, that were going to push the performance of our systems to levels never seen before. Of the many things showed in that meeting, very few made any sense to me at the time, but, when management is keen on taking such demonstrations of "knowledge" at face value, and not listening to other parties, means that everyone had to comply and not complain. Well... 10 years past and nothing of what was pushed in that meeting ever proved to be any efective. This is the first of many things that were pushed then, which I now explain why they are not relevant and should not be adopted in development teams. PLS_INTEGER instead on NUMBER or anchored type variables . Tom Kite said it all here: https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5340131040835 Why didn't it make sense then, and why doesn't it make sense now? several reaso...

In the beggining...

Made my career working for, and after that working with, Oracle. Though I'm not a reference in Oracle world, I see some things every day that are passed around as the ultimate coding practice, but, no evidence to support them. Other things are just common sense, if you stop to thin about them... I will try to publish here my experiences and references on a few things, so maybe they become clearer and useful. Cheers