Re: Parameters Question

2002-04-11 Thread Jared Still
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_

RE: Parameters Question

2002-04-10 Thread Jamadagni, Rajendra
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. _

Re: Parameters Question

2002-04-10 Thread JoJo Zawawi
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

Re: Parameters Question

2002-04-10 Thread Jared Still
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: > > N