我的存储过程总是编译不通过,大家帮忙看一下。谢谢了
create or replace procedure GetWindSumCount(P_FactoryCode in char)
as
begin
select count(*) from pz_windturbine where FACTORYCODE=P_FactoryCode;
end GetWindSumCount;
create or replace procedure GetWindSumCount(P_FactoryCode in char)
as
begin
select count(*) from pz_windturbine where FACTORYCODE=P_FactoryCode;
end GetWindSumCount;
v_n integer;
as
begin
select count(*) into v_n from pz_windturbine where FACTORYCODE=P_FactoryCode;
end GetWindSumCount;