日期:2014-05-17  浏览次数:21127 次

创建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

------解决方案--------------------
探讨
SQL> create or replace procedure sp_select
2 as
3 begin
4 select OrderId,
5 FirstName,
6 LastName,
7 ProductDescription,
8 state,