Weve never used stored procedures in Oracle, and found them somewhat hard to implement. How hard are they to use, and how much work are they to implement?
If you are a Java developer, you wont (shouldnt) have to deal with stored procedures. If you are a database developer, youll be working with dumbed-down stored procedures, because the code will be generated for you for all built-in methods, and the skeleton code will be generated for you for user-defined methods. Nevertheless, we assume that if you are a database developer youll be competent in database technology. We further assert that a development staff that is building a serious database application must have a database developer on staff regardless of the methodology, tools or approach that is adopted. We question the validity of any approach that tries to solve the problem of building industrial strength database applications by eliminating the need for database developers through verbose, restrictive and proprietary APIs such as query objects, expression objects and the like.