Hi,
please who can tell me why my cursor fetch me only the data of first row.
DECLARE
/* Explicit declaration of a cursor */
CURSOR CUR IS
SELECT ALL ID_BOSS,CNSS_BOSS
FROM MATRICULE_CNSS_BOSS;
BEGIN
/* Check to see if cursor is already open. If not, open it. */
IF NOT cur%ISOPEN
THEN
OPEN cur;
END IF;
FETCH cur INTO :BOSS,:CNSS;
CLOSE cur;
END;
i like to fetch all the rows thx