What are the different types of parameter modes available in plsql procedures ? Thank you for the answer in advance.
asked Jan 11 '10 at 12:00 PM in Default
Parameters can be of type: IN - read only OUT - write - no initial value, value must be supplied by procedure INOUT - read/write - new value should be supplied by procedure
Additionally you can specify NOCOPY, which means the compiler "might" (to quote the documentation) pass by reference rather than by value.
(The SHAKEITALLABOUT mode was considered, but rejected :-) )
answered Jan 11 '10 at 01:28 PM