\begin{sql}
 \gray CREATE OR REPLACE PROCEDURE list_cities  (the\_country country.code\%TYPE) \\
 \gray IS \\
 \gray BE\=\gray GIN \\
 \> DEC\=LARE CURSOR {\blue cities\_in} \\
 \>  \>(crs\_country country.Code\%TYPE) \\
 \> IS\> SELECT {\blue Name} \\
 \> \> FROM City \\
 \> \> WHERE Country = crs\_country;\\
  \> BEGIN \\
  \> \> FOR {\magenta the\_city} IN {\blue cities\_in}(the\_country)  \\
 \> \> LOOP \\
 \> \>\>\> dbms\_output.put\_line({\magenta the\_city}.{\blue name}); \\
 \> \> END LOOP; \\
 \> END; \\
 \gray END; \\
 \gray /
\end{sql}
