<div>
IN: parameter is passed in<br />
OUT: parameter is passed out<br />
IN OUT: parameter is passed in and passed out<br />
<br />
For IN, the argument value in the caller will not change, even if the procedure changes it internally.<br />
<br />
For OUT, the argument value cannot be read by the procedure until the procedure itself writes it.<br />
<br />
For OUT and IN OUT, the argument must be a writeable variable (i.e. not a literal).<br />
<br />
Jeff
</div>


IN: parameter is passed in
OUT: parameter is passed out
IN OUT: parameter is passed in and passed out

For IN, the argument value in the caller will not change, even if the procedure changes it internally.

For OUT, the argument value cannot be read by the procedure until the procedure itself writes it.

For OUT and IN OUT, the argument must be a writeable variable (i.e. not a literal).

Jeff

<div>
Dear Jeff,<br />
<br />
can you explain it with any example then only it will be fisible for me.<br />
<br />
Thanks in advance,<br />
ajay
</div>


Dear Jeff,

can you explain it with any example then only it will be fisible for me.

Thanks in advance,
ajay

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
Can any one tell me about the difference and functionality of IN , OUT , INOUT type parameter in procedure , what will be the functionality for each one and how they will effect for package and my program.<br />
<br />
ajay
</div>
</div>


Hi All,

Can any one tell me about the difference and functionality of IN , OUT , INOUT type parameter in procedure , what will be the functionality for each one and how they will effect for package and my program.

ajay

Oracle Procedure Parameter

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.