新建一个最简单的储存过程都建不了呢？

[JavaNet的牛肉粉丝]

create or replace procedure P_DC_ProcurementData
is
begin
select *from dc_inventorydata;
end

[JavaNet的牛肉粉丝]

在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

[rogueskilldanie]

晕。。。少了一个";"

[yinan9]

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;

最后，弱弱的建议下，这样的问题本应通过基础学习来解决，楼主需多些耐心，打牢基础。

[JavaNet的牛肉粉丝]

我后面加了个分号又有错误提示了:
PROCEDURE DMS.P_DC_PROCUREMENTDATA 编译错误
错误：PLS-00428: an INTO clause is expected in this SELECT statement
行：4
文本：select * from dc_inventorydata;



在oracle里写个存储过程这么复杂啊

[ssqtjffcu]

create or replace procedure P_DC_ProcurementData is
begin
  select * from dc_inventorydata;  --这个select语句不能直接这么写，select语句是select出一堆记录，你这样写，没意义，又不赋值，又不能展示结果。好好看看书先
end

[JavaNet的牛肉粉丝]

谢谢各位比SQLSERVER复杂呵呵。