pl/sql developer 툴에서 아래쿼리를 돌려서 생성한 후에
CREATE TABLE emp_t AS SELECT * FROM emp;
CREATE OR REPLACE PACKAGE emp_t_info AS --Package Spec
PROCEDURE all_emp_t_info;
END emp_t_info;
CREATE OR REPLACE PACKAGE BODY emp_t_info AS --Package Body
PROCEDURE all_emp_t_info
IS
CURSOR emp_t_cursor IS
SELECT empno, ename, to_char(hiredate, 'RRRR/MM/DD') hiredate
FROM emp_t
ORDER BY hiredate;
BEGIN
FOR aa IN emp_t_cursor LOOP
DBMS_OUTPUT.PUT_LINE('사번 : '||aa.empno);
DBMS_OUTPUT.put_line('성명 : '||aa.ename);
DBMS_OUTPUT.PUT_LINE('입사일 : '||aa.hiredate);
LOOP END;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(SQLERRM||'에러 발생 ');
END all_emp_t_info;
END emp_t_info;
BEGIN
emp_t_info
END;
로 돌려보면 ORA-04063 : package body "APPS.EMP_T_INFO" has errors
ORA-06508 : PL/SQL : could not find program unit being called : "APPS.EMP_T_INFO"
ORA-06512 : at line 2
이렇게 나오네요.. 무엇이 문제인지 설명좀 해주세요..ㅠ