Hello Good morning all ;
i want to know programming logic for pl/sql code, what i have written ;
because i was lagging yesterday to resolve simple error.
>> This is link https://forums.oracle.com/thread/2565867
ok now i have written my same programming code , but little modification :
now it's working. as i said above , i want to know programming logic "execution flow steps" for pl/sql code
1 DECLARE
2 a number :=10;
3 b number :=20;
4 c number;
5 procedure findmin(x IN number , y IN number , Z OUT number) IS
6 BEGIN
7 <<BLOCK1>>
8 if x < Y then
9 z:=x;
10 else
11 z:=y;
12 end if;
13 END;
14 BEGIN
15 <<BLOCK2>>
16 findmin(a,b,c);
17 DBMS_OUTPUT.PUT_LINE(c);
18* END;
19 /
10
PL/SQL procedure successfully completed.
>> Is this process flow ? >>
1. Declaration part .
2. when reading findmin on line no 5 then control goes to line no 16.
3. Aftrer receving input values , control again goes to 5
4. then compiler will execute the code accordingly.
Question : how many Oracle compiler will execute written code ?