Home » SQL & PL/SQL » SQL & PL/SQL » Reg-Parameters.
Reg-Parameters. [message #37120] Fri, 18 January 2002 20:18 Go to next message
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 Go to previous messageGo to next message
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.
Re: Reg-Parameters. [message #37162 is a reply to message #37120] Mon, 21 January 2002 20:52 Go to previous message
dinakar shetty
Messages: 29
Registered: January 2002
Junior Member
Small addition
u cant assign default values to in Out parameters
as u do for In parameters
Previous Topic: Form gets Locked
Next Topic: Using create ... in trigger
Goto Forum:
  


Current Time: Sat Apr 20 10:27:23 CDT 2024