当前位置：首页 → 问答吧 → 创建stored procedure时出现错误：PLS-00428，如何修改？谢谢大侠~

创建stored procedure时出现错误：PLS-00428，如何修改？谢谢大侠~

时间：2011-11-16

来源：互联网

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

作者: play_cheng 发布时间: 2011-11-16

存储过程中写select语句要有into

作者: rfb0204421 发布时间: 2011-11-16

引用楼主 play_cheng 的回复:
SQL> create or replace procedure sp_select
2 as
3 begin
4 select OrderId,
5 FirstName,
6 LastName,
7 ProductDescription,
8 state,

改成：
create or replace procedure sp_select
as
vs_OrderId varchar2(10) := '';
vs_FirstName varchar2(10) := '';
...
begin
select OrderId，FirstName, ... into vs_orderid, vs_firstname, ....
...

作者: yixilan 发布时间: 2011-11-16

引用 2 楼 yixilan 的回复:
引用楼主 play_cheng 的回复:
SQL> create or replace procedure sp_select
2 as
3 begin
4 select OrderId,
5 FirstName,
6 LastName,
7 ProductDescription,
8 state,

改成：
create or replace procedure sp_se……

2楼正解
lz这大早上爬起来发帖问问题,值得我们学习.

作者: tx2730 发布时间: 2011-11-16