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