HomeOracle Page 5 - Database Interaction with PL/SQL, Working with TABLE in Sub-programs, Parameter Modes
What is an IN OUT type of parameter? - Oracle
This is part 15 of a series of articles focusing on database interactions with Oracle PL/SQL. In my previous article, we looked at several examples that covered the use of sub-programs. In this article we will work with PL/SQL TABLE types in between sub-programs. We will also discuss IN, OUT and IN OUT types of parameters in this article.
The IN OUT type of parameter is special type of parameter which can be accessed and modified. Both operations can be done using an IN OUT parameter. We can rewrite the above program as follows with the concept of an IN OUT parameter:
b number := 10; procedure doSquare(z IN OUT number) is begin