一个关于Oracle存储过程的问题

Question

create procedure orderProduct
(order_no in number) as
begin
select orderNo,sum(qty)
from orderDetail
where orderNo=order_no;
end;
/
警告: 创建的过程带有编译错误。

Answer 1

select orderNo,sum(qty)  INTO 
from orderDetail
where orderNo=order_no;
缺少INTO

Answer 2

create procedure orderProduct
(order_no in number) as
  strOrderNo varchar2(1000);
  iQty int;
begin
select orderNo,sum(qty) into strOrderNo,iQty
from orderDetail
where orderNo=order_no;
end;

Answer 3

create or replace orderProduct (order_no in number ) IS
begin
.....
EXCEPTION
   WHILE OTHERS THEN
      .....
END;