ORACLE存储过程报错PLS-00905 存储过程无效

2025-03-26 16:50:09
推荐回答(1个)
回答1:

CREATE OR REPLACE PROCEDURE proc_trade() as
begin
select * from trade;
end;
问题是这个存储过程没有编译成功,有报错,问题在select查询到数据之后需要输出,
CREATE OR REPLACE PROCEDURE proc_trade() as
a number;
begin
select count(*) into a from trade;
end;