创建stored procedure时出现错误:PLS-00428,如何修改?谢谢大侠~ 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