SQL> create or replace procedure sp_select
2 as
3 begin
4 select OrderId,
5 FirstName,
6 LastName,
7 ProductDescription,
8 state,
9 case when state ='IL'or state ='MD'or state ='CA' then '***' else to_char(Qty) End Qty,
10 case when state ='IL'or state ='MD'or state ='CA' then '***' else to_char(ItemPrice) End
ItemPrice,
11 case when state ='IL'or state ='MD'or state ='CA' then '***' else to_char(ExtendedPrice)
End ExtendedPrice
12 from labfpo;
13 end
14 ;
15 /SQL> show erro
PROCEDURE SP_SELECT 出现错误:LINE/COL ERROR
-------- -----------------------------------------------------------------
4/1 PLS-00428: an INTO clause is expected in this SELECT statement
2 as
3 begin
4 select OrderId,
5 FirstName,
6 LastName,
7 ProductDescription,
8 state,
9 case when state ='IL'or state ='MD'or state ='CA' then '***' else to_char(Qty) End Qty,
10 case when state ='IL'or state ='MD'or state ='CA' then '***' else to_char(ItemPrice) End
ItemPrice,
11 case when state ='IL'or state ='MD'or state ='CA' then '***' else to_char(ExtendedPrice)
End ExtendedPrice
12 from labfpo;
13 end
14 ;
15 /SQL> show erro
PROCEDURE SP_SELECT 出现错误:LINE/COL ERROR
-------- -----------------------------------------------------------------
4/1 PLS-00428: an INTO clause is expected in this SELECT statement
create or replace procedure sp_select
as
vs_OrderId varchar2(10) := '';
vs_FirstName varchar2(10) := '';
...
begin
select OrderId,FirstName, ... into vs_orderid, vs_firstname, ....
...