Originally posted by naidu gulla: hi javaranchers, i would like to know the disadvantages of storedprocedures. thanks in advance
Different databases have different stored procedure languages; some databases don't support stored procedures at all. While at least one database supports Java as a stored procedure language, most don't, so Java programmers who are going to write stored procedures must learn an additional language; however, some companies who use Java and stored procedures have different people or groups work in each area, which of course leads to the normal boundary/integration issues of software development.
Particularly in companies that divide the work, Java programmers might have difficulty getting visibility into the logic implemented in the stored procedures (if they need it), but this can be worked around with good development practices, such as keeping stored procedure definitions in an accessible source code repository. The Java team may also require additional daatabase-related tools. Using stored procedures well often requires more understanding of your particular database product, in particular learning any built-in packages.