Infinate loop in flowchart diagram in 'Intro to PL/SQL' section

51 views
Skip to first unread message

Ligaya Turmelle

unread,
Jan 5, 2016, 9:33:24 AM1/5/16
to Beginning Oracle Database 12c Administration
On page 42 in Figure 2-10 (Flow chart for the employee_updates procedure) you have an infinite loop. Once the logic is past the 'Record Found' check - there is no way to exit the program. I believe that the second "Fetch Cursor" action/process should go back to the "Record Found" decision check.

Iggy Fernandez

unread,
Jan 5, 2016, 10:03:11 AM1/5/16
to Beginning Oracle Database 12c Administration
Absolutely correct! I will add your correction to the Errata section on the Apress website with credit to you. I've attached a corrected version of the diagram.
PL_SQL.png
Reply all
Reply to author
Forward
0 new messages