存储过程如下:
SQL> create procedure proc_luo as
2 begin
3 select * from soldierluo.a_luo;
4 exception
5 end;
6 /警告: 创建的过程带有编译错误。
SQL> create procedure proc_luo as
2 begin
3 select * from soldierluo.a_luo;
4 exception
5 end;
6 /警告: 创建的过程带有编译错误。
select * from soldierluo.a_luo;
语法不对,因该是select ...into... from ...
不是有效的pl/sql语法,select col1 into v_col from table where ...
如果你只要select * from soldierluo.a_luo;的效果的话,直接执行就好了,不用建过程
l_rowdata soldierluo%rowtype;
begin
select *
into l_rowdata
from soldierluo.a_luo
where rownum=1;
exception when others then
null;
end;
/