logo

Crowdly

Browser

Add to Chrome

Consider the following code: CREATE OR REPLACE PROCEDURE update_values (  ...

✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.

Consider the following code:

CREATE

OR REPLACE PROCEDURE update_values (

    p_num1  IN     NUMBER,  

    p_num2  OUT    NUMBER,  

    p_num3  IN OUT NUMBER   

) IS

BEGIN

    p_num2 := p_num1 * 2;

    p_num3 := p_num3 + p_num2;

 

    DBMS_OUTPUT.put_line('Inside procedure:');

    DBMS_OUTPUT.put_line('p_num1 (IN)     = ' || p_num1);

    DBMS_OUTPUT.put_line('p_num2 (OUT)    = ' || p_num2);

    DBMS_OUTPUT.put_line('p_num3 (IN OUT) = ' || p_num3);

END;

/

And the following program:

DECLARE

    v1 NUMBER := 5;

    v2 NUMBER;        -- OUT parameter

    v3 NUMBER := 10;  -- IN OUT parameter

BEGIN

    update_values(v1, v2, v3);

 

    DBMS_OUTPUT.put_line('Outside procedure:');

    DBMS_OUTPUT.put_line('v1 = ' || v1);

    DBMS_OUTPUT.put_line('v2 = ' || v2);

    DBMS_OUTPUT.put_line('v3 = ' || v3);

END;

/
Question:

After executing the code, what will be the final values of the variables outside the procedure?

100%
100%
0%
0%
0%
More questions like this

Want instant access to all verified answers on moodle.uowplatform.edu.au?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Browser

Add to Chrome