In this topic, you will learn about, Difference between procedure and function.

Difference between procedure and function:

FUNCTION	PROCEDURE
The function must return a value.	The procedure can return zero or n values.
Functions can have only input parameters.	Procedures can have input/output parameters.
Functions can be called from Procedure.	Procedures cannot be called from Function.
For exception handling, a try-catch block cannot be used in a Function.	The exception can be handled by try-catch block in a Procedure

Comment