Values of any IN OUT parameters are copied before subprogram is executed - Tuning PL/SQL Applications

Q.  The values of any IN OUT parameters are copied before the subprogram is executed.
- Published on 01 Jul 15

a. Yes
b. No

ANSWER: Yes
 
The IN OUT parameters are passed by values by default. During the subprogram execution the temporary variables hold the output parameter values. If the program is normal the values are copied to the actual parameters. If the program exits with an unhandled exception the original parameters remain unchanged.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)