create or replace procedure pro8_1
is
v_empno emp.empno%type;
v_ename emp.ename%type;
v_dname emp.dname%type;
cursor result is
select empno, ename, dname
from emp natural join dept
where sal > 2000
order by dname;
begin
open result;
loop
fetch result into v_empno, v_ename, v_dname;
exit when result%notfound;
dbms_output.put_line('사원번호:'||v_empno||' 사원이름:'
||v_ename||' 부서이름:'||v_dname);
end loop;
close result;
end pro8_1;
이렇게 만들면
PLS-00103:Encoutered the symbol "CREATE" 라는 문구가 떠요 모든 프로시저 만들려고하면
이런에러가뜨더라구요 왜이런거죠?? ㅠㅠ |