I have part of my procedure something like this:
declare
v_cnt_1 number;
v_cnt_2 number;
begin
with input1 as(
select .........
from...
where.....)
select count(*) into v_cnt_1
from input1 t
where......);
with input2 as(
select .........
from...
where.....)
select count(*) into v_cnt_2
from input2 t
where......);
IF v_cnt_1 >0 or v_cnt_2 >0
THEN DBMS_OUTPUT.PUT_LINE('all set');
ELSE DBMS_OUTPUT.PUT_LINE('take further action');
end if;
end;
my goal here is :if this query returns the result of 'take further action' then i have to implement other steps which if further if/else statement. I have four more situation(if/else) to add if this returns 'take further action'. how can i add if/else on the basis of this output? Or do i need to create another procedure and call this procedure inside new procedure?
Aucun commentaire:
Enregistrer un commentaire