楼上的,还是不对呀 i_name in aaa.c_name%type,我在OEMC中此句有错,不知错在何处
c_name:=i_name; -->c_name=i_name;
我就说嘛,我没听过见过in、out 的语法,也许是我不知道吧 声明错了 create or replace procedure count_num (i_name aaa.c_name%type, i_count char(4)) as begin select count(*) into i_count from aaa where c_name:=i_name; dbms_output.putline(i_count );end;
i_name in aaa.c_name%type,我在OEMC中此句有错,不知错在何处
-->c_name=i_name;
声明错了
create or replace procedure count_num
(i_name aaa.c_name%type,
i_count char(4))
as
begin
select count(*) into i_count from aaa where c_name:=i_name;
dbms_output.putline(i_count );end;
to welyngj还是不正确
->
i_count out number
->
where c_name=i_name;