Re: Stored Program Units in Oracle 7
From: Michael Krolewski <vandra_at_u.washington.edu>
Date: Fri, 08 May 1998 00:18:51 -0700
Message-ID: <3552B1DB.33C710B3_at_u.washington.edu>
Date: Fri, 08 May 1998 00:18:51 -0700
Message-ID: <3552B1DB.33C710B3_at_u.washington.edu>
It should be in the PL/SQL manual...
procedure foo ( some_variable input_putput_mode variable_type, ...)
some_other_var variable_type; -- local variables begin
end
Each parameter variable has a name, a mode and a type. Mode are:
IN meaning the variable is read in only, internal changes will not change
the original value.
OUT meaning the variable is modified and the calling
program/procedure
will be able to see the change. Note, cannot pass in data
with this
IN_OUT combination of the above information.
Mike Krolewski
Christophe wrote:
> Hello!
> I have a problem.
> I have to create some stored program units but i can't find how to declare
> parameters in help documentation on the Oracle 7 CR-ROM.
> Thanks for sending to me a sample at : lsa.perinfo_at_wanadoo.fr
Received on Fri May 08 1998 - 09:18:51 CEST