Re: Parameters Question
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).
RE: Parameters Question
create or replace my_demo_proc (param_1 in varchar2, param_2 in number) is
begin
null;
end;
Now param_1 and param_2 are named parameters but
begin
my_demo_proc('ABC', 20);
end;
/
The "ABC" and 20 are actual parameters. Named parameters are also known as
formal parameters.
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
***1
This e-mail message is confidential, intended only for the named recipient(s) above
and may contain information that is privileged, attorney work product or exempt from
disclosure under applicable law. If you have received this message in error, or are
not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and
delete this e-mail message from your computer, Thank you.
***1
Re: Parameters Question
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: JoJo Zawawi 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).
Re: Parameters Question
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).
