create or replace procedure test(v_name string)
as
...
v_i integer;
begin
...
select count(*) into v_i from tableA where name=''||v_name||'';
if v_i>0 then
...
else
...
end if;
...
as
...
v_i integer;
begin
...
select count(*) into v_i from tableA where name=''||v_name||'';
if v_i>0 then
...
else
...
end if;
...
SELECT INTO 不就可以了吗?