The differences between Stored procedures and Functions are given below:

See also :

• JDBC : Stored Procedure Example
• JDBC : Function Example

Stored Procedure	Function
Is used to perform business logic.	Is used to perform calculation.
Must not have return type.	Must have the return type.
May return zero or more values.	May return only one values.
We can call function from procedure.	Procedure can not be call from function.
Procedure supports input and output parameters	Function supports only input parameters.
Exception handling using try/catch block can be used in stored procedures.	Exception handling using try/catch can’t be used in user defined functions.

More on JDBC

Follow below links to learn more posts on JDBC and solving JDBC related issues :

• JDBC Tutorial
• JDBC Sample Code
• JDBC Issues and Solutions
• JDBC Interview Questions And Answers
• JDBC Coding Best Practices