Re: pl/sql question

dbase is a 'record' which you can't directly use with dbms_output.put_line, you need to use

dbms_output.put_line(to_char(dbase.field1));

where field1 is the column that is returned from your databases_cursor.

V. Hawkins wrote in message ...
>
> FOR dbase IN databases_cursor(ctg_row.assignment_id) LOOP
> EXIT WHEN databases_cursor%NOTFOUND;
> -- works DBMS_OUTPUT.PUT_LINE ('dbase');
> DBMS_OUTPUT.PUT_LINE (TO_CHAR(dbase));
> END LOOP;
>
>Thanks
>Victoria Hawkins
>
>
>
>
Received on Fri Oct 09 1998 - 02:35:01 CDT