当前位置: 代码迷 >> Oracle开发 >> 简略存储过程报错
  详细解决方案

简略存储过程报错

热度:15   发布时间:2016-04-24 07:22:05.0
简单存储过程报错
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;
  相关解决方案