What is the difference between Java Stored Procedure and Oracle Stored procedures? Stored procedures are group of sql statement that will be called withnin a program. Am I right? How can we use either Oracle Stored procedures or Java Stored Procedures. Any sample program or site that having sample coding will be useful to begin with for beginners like me!!
Oracle Stored Procedures will be written in PL/SQL, Java Stored Procedures will be written in Java. The "PL/SQL User Guide" and "Java Stored Procedures Developer's Guide" in Oracle's documentation are good starting points.