Which two subprograms will be created successfully?
A. CREATE FUNCTION p4 (y pkg.tab_typ) RETURN pkg.tab_typ ISBEGINEXECUTE IMMEDIATE ‘SELECT
pdt_id, pdt_name FROM TABLE (:b)’BULT COLLECT INTO pkg.x USING y;RETURN pkg.x;END p4;
B. CREATE PROCEDURE p1 (y IN OUT pkg.tab_typ) ISBEGINEXECUTE IMMEDIATE ‘SELECT f (:b) FROM
DUAL’ INTO y USING pkg.x;END p1;
C. CREATE PROCEDURE p2 (v IN OUT VARCHAR2) ISBEGINEXECUTE IMMEDIATE ‘SELECT f (:b) FROM
DUAL’ INTO v USING pkg.x;END p2;
D. CREATE FUNCTION p3 RETURN pkg. tab_typ ISBEGINEXECUTE IMMEDIATE ‘SELECT f (:b) FROM DUAL’
INTO pkg.x;END p3;
E. CREATE PROCEDURE p5 (y pkg. rec_typ) ISBEGINEXECUTE IMMEDIATE ‘SELECT pdt_name FROM TABLE
(:b)’ BULK COLLECT INTO y USING pkg.x;END p5;
Answer: A,C
