The differences between Stored procedures and Functions are given below:
See also :
|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 API introduced statement, PreparedStatement and CallableStatemnet to execute different types of queries:
- Statement : Used to execute Normal SQL Queries.
- PreparedStatement: Used to execute dynamic or parameterized queries.
- CallableStatement: Used to execute StoredProcedure.
Statement Vs PreparedStatement Vs CallableStatement
|It is used to execute normal SQL queries.
||It is used to execute dynamic or parameterized SQL queries.
||It is used to execute Stored procedure or function.
|It is proffered when particular query to be executed only once.
||It is proffered when particular query to be executed multiple times.
||It is proffered when stored procedure or functions to be executed.
|You can no pass parameter to query by using this interface.
||You can pass parameter to query at run time by using this interface.
||You can pass three types of parameters by using this interface IN, OUT and IN OUT
|This interface mainly used for DDL statements like CREATE, ALTER , DROP etc.
||This is used to be any kind of SQL queries which are used multiple times
||It is used with Stored Procedure and functions.
|The performance of this interface is very low.
||The performance of this interface is better than query while using with multiple queries.
||Performance of this interface is very high because stored procedure execute on database end.
|For More: Statement
||For More: Prepared Statement
||For More: Callable Interface
Learn More on JDBC
Follow below links to know more on JDBC and solving JDBC issues :