0 votes
in IONIC by

What is the difference between Function and Stored procedure?

1 Answer

0 votes
by

Stored Procedure:

A Stored Procedure is always used to perform a specific task.

It can return zero, one or more value.

It can have both input and output parameters.

Exception handling can be done using a try-catch block.

A function can be called from a Procedure.

Functions:

Functions must return a single value.

It can only have the input parameter.

Exception handling cannot be done using a try-catch block.

A Stored procedure cannot be called from a function.

Related questions

0 votes
asked Mar 18, 2021 in PL/SQL by sharadyadav1986
0 votes
asked Jun 13, 2023 in Sqoop by rahuljain1
...