麻烦那位高手帮忙解答一下,出现这个错误不知道为什么
SQL> l
1create or replace procedure mm
2as
3begin
4select * from emp;
5* end;
SQL> /
Warning: Procedure created with compilation errors.
SQL> show error;
SQL> show error
Errors for PROCEDURE MM:
LINE/COL ERROR
-------- -----------------------------------------------------------------
4/1PLS-00428: an INTO clause is expected in this SELECT statement
直接用匿名块也不行
SQL> begin
2select * from emp;
3end;
4/
select * from emp;
*
ERROR at line 2:
ORA-06550: line 2, column 1:
PLS-00428: an INTO clause is expected in this SELECT statement