Reg-Parameters. [message #37120] |
Fri, 18 January 2002 20:18 |
Nantha
Messages: 4 Registered: December 2001
|
Junior Member |
|
|
Hi ,
Please send the details and difference between IN,OUT,INOUT parameters in plsql.
Thanks in advance.
With love
Nantha
|
|
|
Re: Reg-Parameters. [message #37126 is a reply to message #37120] |
Sat, 19 January 2002 08:23 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
there is clear explanation in oracle documentation.
IN mode - Default mode - you can pass values to procedure or function , but you cant assign any value to this parameter (read only variable)
OUT mode - you have to specify explicitly - it returns value to caller program. you can assign value to this parameter inside procedure or function.
IN OUT mode: you can pass value to procedure and returns value.
|
|
|
|