1. Invoke an existing Procedure called Emp_Name (iId IN NUMBER, oEmp_FullName OUT VARCHAR2) in an Anonymous Block. Code the statements necessary so you can see message displayed by the stored procedures.

2. Create a single anonymous block to test the procedure discussed above.

a. Define a variable for the Employees table's primary key. Name the variable wEmployeeID and define as a number with 6 digits.

b. Define a variable to be used with the oEmp_FullName parameter of 'Emp_Name'. It must be a character field with a maximum of 30 bytes long.

c. Call the Emp_Name stored procedure.

* The ID field must be passed using the defined field in step 'a' above. It must have a value of one(1).

* The result returned by Emp_Name must be stored in the field defined in 'b' above.

* After the call, display a message "The employee ID# 1 is Even Matias."

Note: This assignment is doing with PL/SQL and make sure the output is shown in your client after executing Anonymous Block.

Emplo Employees NUMBER) VARCHAR20 VARCHAR2) VARCHAR2201 Lastline Emplo Employees NUMBER) VARCHAR20 VARCHAR2) VARCHAR2201 Lastline