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: <[EMAIL PROTECTED]>; "JoJo Zawawi" <[EMAIL PROTECTED]>
> 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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to