存储过程:
create or replace procedure zhanshi(v_pid article.pid%type) is
cursor c is
select * from article where pid = v_pid;
begin
for v_article in c loop
dbms_output.put_line(v_article.cont);
if (v_article.isleaf = 0) then
zhanshi(v_article.id);
end if;
end loop;
end;
TEST:
begin
-- Call the procedure
zhanshi(v_pid => :v_pid);
end;
修改为:
begin
zhanshi(:v_pid => 0);
end;