I thought the best way to trigger this blog is to discuss the rationales for stored procedures, the obstacles to their adoption, languages used for writing stored procedures, and the $100000 question of proprietary procedural languages such as PL/SQL versus open standards languages such as Java.
http://www.oracle.com/technology/books/pdfs/mensah_ch1.pdf
Enjoy and share your thoughts, Kuassi
