- 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;