Traitement simplifié
DECLARE
CURSOR cursLivre IS SELECT liv_num, liv_titre FROM livre ORDER BY liv_num;
recordCursLivre cursLivre%ROWTYPE;
BEGIN
OPEN cursLivre;
LOOP
FETCH cursLivre INTO recordCursLivre;
EXIT WHEN (cursLivre%NOTFOUND);
...
END LOOP;
CLOSE cursLivre;
END;