读书人

简略存储过程报错

发布时间: 2012-09-19 13:43:54 作者: rapoo

简单存储过程报错

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; 

读书人网 >oracle

热点推荐