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

Dbms_output.put_line is working, else you would not see 'this is the course'. What's not working is having a value in v_course at the time you print the line.

Van

<" srcnckpc"_at_hotmail.com> wrote in message news:3AC2EF42.EC15DF5D_at_hotmail.com...
> 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 Fri Mar 30 2001 - 04:50:12 CEST