-
IN identifica o parâmetro como sendo do tipo “entrada”. Existem também os parâmetros do tipo OUT e do tipo IN OUT
-
IN - The parameter can be referenced by the procedure or function. The value of the parameter can not be overwritten by the procedure or function.
OUT - The parameter can not be referenced by the procedure or function, but the value of the parameter can be overwritten by the procedure or function.
IN OUT - The parameter can be referenced by the procedure or function and the value of the parameter can be overwritten by the procedure or function.
Fonte: oracle doc
go @head
-
a-
1) IN type parameter: These types of parameters are used to send values to stored procedures.
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://plsql-tutorial.com/plsql-passing-parameters-procedure-function.htm