Oracle PL/SQL Return in Blocks

Question

Just a question since I can't seem to find the answer somewhere else.

So I got an PL/SQL function which contains a nested block, and within the 2nd level block it got a return value of 1. Does this mean that it will not proceed to the next block and return the value 1 or it will only terminate the current block?

Thanks!

Sample structure for illustration:

FUNCTION EXAMPLE ( sample_variable VARCHAR2)
    RETURN NUMBER
IS
    BEGIN 
       BEGIN
          /*CODES HERE*/
       EXCEPTION
           WHEN OTHERS THEN
           RETURN 1; //HERE IS THE QUESTION. WHEN I GOT HERE IN RETURN DOES IT TERMINATE THE WHOLE 
                     //FUNCTION AND RETURN 1 OR IT WILL STILL CONTINUE TO BLOCK 2*/
       END;
       BEGIN /*BLOCK 2*/
          /*OTHER CODES HERE*/
          RETURN 2;
       END;
    END
 END EXAMPLE;

Juan Diego Godoy Robles · Accepted Answer · 2016-05-19 15:54:50Z

3

Terminates the whole function.

From oracle docs:

In a function, the RETURN statement assigns a specified value to the function identifier and returns control to the invoker, where execution resumes immediately after the invocation.

answered May 19, 2016 at 15:54

Juan Diego Godoy Robles

15k2 gold badges43 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle PL/SQL Return in Blocks

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related