Skip to Main Content

How to fix this error?

jdev1Jan 25 2021

Hello all,

I am working in pl/sql and my task is Create a procedure to display up to 30 employees on the screen. Display the employees sorted by department id and
employee id in ascending order. Do not show more than 10 employees from one department even if there are more
employees there. Use two nested loops – one for all departments and another for employees in each department. The
result should be displayed as follows:
#1: Whalen (#1 in dept 10)
#2: Hartstein (#1 in dept 20)
#3: Fay (#2 in dept 20)
#4: Raphaely (#1 in dept 30)
...
#26: Baer (#1 in dept 70)
#27: Russell (#1 in dept 80)
#28: Partners (#2 in dept 80)
#29: Errazuriz (#3 in dept 80)
#30: Cambrault (#4 in dept 80). But I am getting error in loop:
err.PNG

Comments
Post Details
Added on Jan 25 2021
49 comments
158 views