create or replace procedure wangx.test
is
begin
declare v_receive number(2);
select value into v_receive 
from wangx.test_20120821 
where value=1;
end;

报错信息：
Compilation errors for PROCEDURE WANGX.TEST

Error: PLS-00103: 出现符号 "SELECT"在需要下列之一时：
        begin function package
          pragma procedure subtype type use <an identifier>
          <a double-quoted delimited-identifier> form current cursor
Line: 5
Text: select value into v_receive

Error: Hint: Variable 'select' is declared but never used in 'wangx.test'
Line: 5
Text: select value into v_receive

create or replace procedure wangx.test
is
v_receive number(2);
begin
select value into v_receive 
from wangx.test_20120821 
where value=1;
end;