15일차 # 1-16: DEFAULT

        create or replace procedure up_proc_default (

   p_deptno in emp.deptno%type := 10

 , p_minsal in emp.sal%type default 2000)

is

begin

 for r in (select * from emp

   where deptno = p_deptno

   and sal >= p_minsal)  loop

   p(r.deptno || ' ' || r.empno || ' ' || r.ename || ' ' || r.sal);

 end loop;

end;

/

set serveroutput on

exec up_proc_default

exec up_proc_default(20)

exec up_proc_default(20, 1000)

exec up_proc_default(default, 1000)

==> 오류: ORA-06550: 줄 1, 열23:PLS-00103: 심볼 "DEFAULT"를 만났습니다

↓ ↓ ↓ 

exec up_proc_default(p_minsal => 1000)