17,377
社区成员
发帖
与我相关
我的任务
分享
SQL> create or replace procedure t_testt(i_num number)
2 as
3 v_num number(2);
4 begin
5
6 if i_num=1 then
7 select 1 into v_num from dual;
8 dbms_output.put_line('level 2 ');
9 elsif i_num=2 then
10 dbms_output.put_line('level 1 ');
11 t_testt(1);
12 else
13 select 1 into v_num from dual;
14 end if;
15
16 end;
17 /
Procedure created
SQL> set serveroutput on
SQL> exec t_testt(2);
level 1
level 2
PL/SQL procedure successfully completed
SQL>