✅ 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 ) ISBEGIN 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 parameterBEGIN 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;/