Examine the following code:
What is the outcome?
A.
The procedure is created successfully and displays the values 20 and 30 when it is called.
B.
The procedure gives errors because the parameters should be in out mode.
C.
The procedure gives errors because the host variables cannot be referenced anywhere in the
definition of a PL/SQL stored procedure.
D.
The procedure is created successfully but does not display any values when it is called
because the host variables cannot be displayed inside the procedure.
C
C
c
C
C is correct Ans
CREATE OR replace procedure xyz (:n1 in out number) is
begin
:n1 := 20;
dbms_output.put_line(:n1);
end;
D is trap answer.
Host variables cannot be referenced anywhere in subprograms.
And NOT because host variables cannot be displayed inside the subprogram.
C
C
c