PL/SQL Stored Procedure Question

Have anyone encountered the following problem:

The following create procedure is fine.

SQL> create procedure addemp (emp_name char) is   2 begin

  3     insert into emp (empno, ename)
  4        values (empno_seq.nextval, emp_name);

Procedure created.  

SQL> create procedure delemp (emp_id number) is   2 begin
  3 delete emp where empno = emp_id;   4 end;
  5 /  

Procedure created.

The following create procedure is not working.  

SQL> create procedure shwemp (emp_id number) is   2 begin
  3 select empno, ename from emp where empno = emp_id;   4 end;
  5 /  

Warning: Procedure created with compilation errors.

SQL> Your help is greatly appreciated.

-Lyny Received on Fri Jan 19 1996 - 00:00:00 CET