Originally posted by Bill Goldsworthy:
A stored procedure is a program which is physically stored in the database.
I'm not sure what you mean by 'prefer Java Stored procedure to DB Stored Proc'.
Many modern RDBMS accept there stored procedures written in Java, in addition to the native format. Those stored procedures are called "Java Stored Procedures". The question, as I understand it, is: which format should be preferred when, and why?
The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus