Re: Parameters Question

From: Jared Still <jkstill_at_cybcon.com>
Date: Thu, 11 Apr 2002 07:18:35 -0800
Message-ID: <F001.00441D0E.20020411071835@fatcity.com>

create or replace procedure my_proc (

	emp_id number,
	plan_id number,
	grp_id number

) is
begin

        blah, blah, blah;
end;

---

v_emp_id number := 1;
v_plan_id number := 2;
v_grp_id number := 3;

Positional parameters:

my_proc( v_emp_id, v_plan_id, v_grp_id );

Named parameters:

my_proc(

	plan_id => v_plan_id,
	emp_id => v_emp_id,
	grp_id => v_grp_id

);

Ordering is unimportant (usually ) for named parameters.

Combinations are possible. See PL/SQL app dev manual for details.

Jared

On Wednesday 10 April 2002 10:03, JoJo Zawawi wrote:
> Jared,
>
> I'm trying to read the Oracle documentation on Forms. (It's a 1,300-page
> PDF file... I'm on page 20, which, after the table of contents, is really
> about page 1 or 2.) So PL/SQL, I guess.
>
> Thanks,
> JoJo
>
>
> ----- Original Message -----
> To: <ORACLE-L_at_fatcity.com>; "JoJo Zawawi" <jojo_at_jojo-zawawi.com>
> Sent: Wednesday, April 10, 2002 7:58 AM
>
>
>
> Context Jojo, context!
>
> Are you talking about PL/SQL, Oracle RDBMS init files,
> something else?
>
> Sounds like PL/SQL to me, but that would be Named
> parameter and Positional Parameter.
>
> Jared
>
> On Tuesday 09 April 2002 20:23, JoJo Zawawi wrote:
> > Hi again, folks!
> >
> > Can someone please define:
> >
> > Named Parameter
> > Actual Parameter
> >
> > I have an idea that "Named Parameter" is a system-provided parameter, but
>
> I
>
> > want to make sure, and be clear on the difference from Actual Parameter.
> >
> > Thanks in advance!!!
> >
> > Cheers,
> > JoJo
>
> ----------------------------------------
> Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
> Content-Transfer-Encoding: quoted-printable
> Content-Description:
> ----------------------------------------

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Apr 11 2002 - 10:18:35 CDT