when will the DBMS_OUTPUT.PUT_LINE not work???

[Quoted] [Quoted] Here's my code.However the DBMS_OUTPUT.PUT_LINE simply does not display the variables in SQL. What is wrong?

DECLARE [Quoted]  TYPE rooms_table_type IS TABLE OF rooms%ROWTYPE

        INDEX BY BINARY_INTEGER;  rooms_table rooms_table_type;

 v_room classes.room_id%TYPE;
 v_dept classes.department%TYPE;
 v_course classes.course%TYPE;

BEGIN   FOR i IN 99999 .. 99991 LOOP

  SELECT *
  INTO rooms_table(i)

       FROM rooms
       WHERE room_id = i;

  SELECT classes.room_id, classes.department, classes.course   INTO v_room, v_dept, v_course
  FROM classes, rooms
  WHERE classes.room_id = rooms.room_id;

  END LOOP; [Quoted]  DBMS_OUTPUT.PUT_LINE(' This is the course' || v_course);

 END;
/

v_course is not displaying at all but 'this is the course' shows up correctly.
Thanks,
SRC Received on Thu Mar 29 2001 - 16:06:09 CEST