Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the difference between a procedure and a function ?

April 26, 2017function procedure

0

Posted

What is the difference between a procedure and a function ?

2 Answers

0

Posted

Functions return a single variable by value whereas procedures do not return any variable by value. Rather they return multiple variables by passing variables by reference through their OUT parameter.

0

Posted

A database procedure is a database object that contains a series of statements and, therefore, forms an independent part of a program. Database procedures are created and stored in the database. They can contain parameters. You can define any number of database procedures. To execute a database procedure, you must call it from an application program using the appropriate SQL statement. A database function is a special database procedure. A database procedure can only have one output parameter.