Q$4.(15$ points$)$ Dynamic SQL$.$ This question uses table EMP.

Below are the codes of a package specification $($finished$)$ and part of the package body $($unfinished$).$You are required to finish the procedure $($codes$)$ that accepts the emp number $($empno$)$ as IN parameter, retrieves the ename and sal to populate the record variable as the out parameter.

After having compiled the package and the package body, write a PL$/$SQL block program. In the block, the program will declare a variable of the Emp$\_$Rec data type defined in the package. The program will run "EXECUTE IMMEDIATE" for the dynamic string:

'BEGIN Emp$\_$pkg$.$Get$\_$Emp$\_$Rec $(7839,$

:dummyplaceholder $)$; END;$\text{'}$;

You need to use the corresponding bind argument for the placeholder in the USING clause.

Then your program will display the result.