简略存储过程报错

简单存储过程报错

SQL code

create or replace procedure wangx.testisbegindeclare v_receive number(2);select value into v_receive from wangx.test_20120821 where value=1;end;报错信息：Compilation errors for PROCEDURE WANGX.TESTError: PLS-00103: 出现符号 "SELECT"在需要下列之一时：        begin function package          pragma procedure subtype type use <an identifier>          <a double-quoted delimited-identifier> form current cursorLine: 5Text: select value into v_receiveError: Hint: Variable 'select' is declared but never used in 'wangx.test'Line: 5Text: select value into v_receive

SQL code

create or replace procedure wangx.testisv_receive number(2);beginselect value into v_receive from wangx.test_20120821 where value=1;end;