How to pass parameters to Procedures and Functions in PL/SQL?
In PL/SQL, we can pass parameters to procedures and functions in three ways.
1) IN type parameter: These types of parameters are used to send values to stored procedures.
![](https://techaid71.xyz/wp-content/uploads/2021/11/Parameter-In-Procedures-PLSQL-Query.jpg)
2) OUT type parameter: These types of parameters are used to get values from stored procedures. This is similar to a return type in functions.
3) IN OUT parameter: These types of parameters are used to send values and get values from stored procedures.
![](https://techaid71.xyz/wp-content/uploads/2021/11/Parameter-In-Procedures-PLSQL-Query-With-Bind-Veriable.jpg)