Procedure Do Not Compile.

I am having problem with this Procedure: Can someone Help me.
.Table emp exist in the Scott's schema.
.scott has unlimited space on the tablespace
. the tablespace USERS is 89% EMPTY.
. scott has DBA Privilege (this is testing Enviroment, so donot be alarmed that scott has DBA privileges).

I also Have same problem if I try compiling FUNCTION.


-----------------------------------------

1 create or replace procedure Emp_Procedure (p_empno in number)
2 begin
3 select ename
4 from emp
5 where empno = P_empno;
6 dbms_output.put_line('this the employee I want to is ' ||' ' ||ename );
7* end;
Youssouf9i--SQL>/

Warning: Procedure created with compilation errors.

Youssouf9i--SQL>exec Emp_Procedure (7766);
BEGIN Emp_Procedure (7766); END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00905: object SCOTT.EMP_PROCEDURE is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Change it into something like:

Code:

---

create or replace procedure Emp_Procedure (p_empno in number)
AS
  v_ename emp.ename%TYPE;
begin
  select ename
  INTO v_ename
  from emp
  where empno = P_empno;
  dbms_output.put_line('this the employee I want to is ' ||' ' ||v_ename );
end;

---

dont you see it says:

Warning: Procedure created with compilation errors?