dbms_output

I have been trying to get this to work for some time and just can't get it to print more than 2000 records. I get a buffer overflow error every time.

Has anyone had any experience using dbms_output to print more than 2000 lines, is there a better method???

                                Thanks for your help, David

• -----------------------------------------------------------

DECLARE

        CURSOR recs_cur IS
        SELECT ss_number,'|' fun,full_name  FROM educator,dual
        WHERE SS_number LIKE '555555%';

        rec recs_cur%ROWTYPE;

BEGIN
 OPEN recs_cur;

        LOOP
                FETCH recs_cur INTO rec;

                IF recs_cur%NOTFOUND
                THEN
                        EXIT;

                ELSE
                        DBMS_OUTPUT.PUT_LINE
                        ('It works ' || rec.ss_number || rec.fun);

                END IF;

                commit;

        END LOOP;

END;
/
-- -----------------------------------------------------------
Received on Mon Jul 15 1996 - 00:00:00 CEST