IN OUT parameters in Procedures

[dilippanda]

Hi,

Please give me an example of a procedure having IN OUT parameters.

Also please let me know the difference between OUT and IN OUT parameters in PL/SQL procedures.

Thanks,
Dilip

[debasisdas]

Please find the all the details of your question here

[dilippanda]

Hi Debashish,

Thanks for the link.
But can you please make me understand what is the difference between OUT and INOUT parameter.I could not make out the difference between OUT and IN OUT Parameter from the link provided by you.

Please help me.

Thanks,
Dilip

Please find the all the details of your question here

[debasisdas]

The out parameter returns the value
The in out parameter can receive as well as return value from the procedure.