Store Procedure Vs Function
| S.No | Particulars | Store Procedure | Function |
| 1 | Return | No return value. | Must return Value. |
| 2 | Parameter | Input/Output. | Input. |
| 3 | Call | can't called to Function. | can called to Store Procedure. |
| 4 | Mandatory Input Paramenter | not Mandatory. | Mandatory. |
| 5 | DML/Select | Allow DML/Select. | Allow Select. |
| 6 | Exception | can be handled. | can not be handled . |
