Re: when will the DBMS_OUTPUT.PUT_LINE not work???

Set Serveroutput ON

" srcnckpc"_at_hotmail.com wrote:

> Here's my code.However the DBMS_OUTPUT.PUT_LINE simply does not display
> the variables in SQL. What is wrong?
>
> DECLARE
>
> 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;
>
> 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 Mon Apr 02 2001 - 04:21:58 CEST