在PL/SQL里面提示: PROCEDURE DMS.P_DC_PROCUREMENTDATA 编译错误错误:PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; <an identifier> <a double-quoted delimited-identifier> delete exists prior <a single-quoted SQL string> The symbol ";" was substituted for "end-of-file" to continue. 行:5 文本:end
1,存储过程最后缺少分号 ; 2,存储过程,或者pl/sql中 select 后缺少into create or replace procedure P_DC_ProcurementData IS num NUMBER; begin select max(empno) INTO num from emp; END;最后,弱弱的建议下,这样的问题本应通过基础学习来解决,楼主需多些耐心,打牢基础。
我后面加了个分号又有错误提示了: PROCEDURE DMS.P_DC_PROCUREMENTDATA 编译错误 错误:PLS-00428: an INTO clause is expected in this SELECT statement 行:4 文本:select * from dc_inventorydata;在oracle里写个存储过程这么复杂啊
create or replace procedure P_DC_ProcurementData is begin select * from dc_inventorydata; --这个select语句不能直接这么写,select语句是select出一堆记录,你这样写,没意义,又不赋值,又不能展示结果。好好看看书先 end
PROCEDURE DMS.P_DC_PROCUREMENTDATA 编译错误错误:PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; <an identifier> <a double-quoted delimited-identifier>
delete exists prior <a single-quoted SQL string>
The symbol ";" was substituted for "end-of-file" to continue.
行:5
文本:end
2,存储过程,或者pl/sql中 select 后缺少into
create or replace procedure P_DC_ProcurementData
IS
num NUMBER;
begin
select max(empno) INTO num from emp;
END;最后,弱弱的建议下,这样的问题本应通过基础学习来解决,楼主需多些耐心,打牢基础。
PROCEDURE DMS.P_DC_PROCUREMENTDATA 编译错误
错误:PLS-00428: an INTO clause is expected in this SELECT statement
行:4
文本:select * from dc_inventorydata;在oracle里写个存储过程这么复杂啊
create or replace procedure P_DC_ProcurementData is
begin
select * from dc_inventorydata; --这个select语句不能直接这么写,select语句是select出一堆记录,你这样写,没意义,又不赋值,又不能展示结果。好好看看书先
end