过程没有创建成功,语句有问题,
首先select *可能导致多值,得用游标
其次过程语句与一般sql语句不同,以SELECT XX INTO XX from XX形式,你都没有into语句,这句话本身就有问题。
create or replace procedure area
is
v_num in number ;
v_ar out number;
begin
select num*num into v_ar from dual where num = v_num;
end area;
类似?
create or replace procedure area ( num number ,v_ar varchar2)
select * into v_areaRecord from dual;
这个语句有问题
select 1 into v_areaRecord from dual;