I came across a very nice post about Autonomous Transactions in Oracle written by Kevin Meade on orafaq. Thought about sharing the link. His blog also has some very nice stuff. Comments Comment by Aman…. on 2008-03-09 12:28:30 +0530 Nice one Sidhu.learned some thing new about AT. 🙂 Cheers, Aman….
Today one of my colleague was working on a simple PL/SQL procedure. Based on some logic it was returning count(*) from all_tab_columns for few tables. It gave count incorrectly for one table out of around fifty in total. He just hard coded the table name and ran it but again it showed count as zero. Then he took the code out of procedure and wrote it in DECLARE, BEGIN, END and after running it showed the correct count. But ran as database procedure it always shows incorrectly. ...