View Exhibit1 and examine the structure of the EMPLOYEES and DEPARTMENTS tables existing in your schema.View Exhibit2 and examine the PL/SQL block that you execute to display the department- wise incremented salary for all the departments in your company.The code generates an error on execution.What correction should be done to ensure the code executes successfully?
View Exhibit1 A 1 (32.29 KiB) Viewed 149 times
A. The cursor variable parameter should be passed in IN OUT mode.
B. The cursor variable should be defined as a strong REF CURSOR type.
C. The cursor variable name passed as actual and formal parameters should be identical.
D. The %NOTFOUND cursor attribute cannot be used with the cursor variables and should be replaced with a user defined exception.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!