Home » SQL & PL/SQL » SQL & PL/SQL » doubt inout procrdure
doubt inout procrdure [message #258542] Mon, 13 August 2007 00:50 Go to next message
oraclelover
Messages: 3
Registered: August 2007
Junior Member
procedure: IN is sending value from calling environment to procedure.
out: is sending vale from procedure to calling environment.

IN OUT : is sending value from calling to procedure and return the value from procedure to calling environment is this correct whether it will return the out parameter.but procedure wont retun the value .it perform only some action i have doubt in this pls clarify it.

dobt in formal,actual parameters.pls clarify that also
Re: doubt inout procrdure [message #258552 is a reply to message #258542] Mon, 13 August 2007 01:09 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Application Developer's Guide - Fundamentals
PL/SQL User's Guide and Reference

Procedures perform actions and return values in OUT and IN OUT parameters. Or if you prefer they set OUT and IN OUT parameters.

Regards
Michel
Previous Topic: Reg:To comeout from the inner blocks
Next Topic: Master Detail View
Goto Forum:
  


Current Time: Thu Dec 08 16:32:55 CST 2016

Total time taken to generate the page: 0.10060 seconds