Re: pl/sql question
From: Stewart Burnett <Stewart_at_burnettms.nospam.demon.co.uk>
Date: 1998/10/09
Message-ID: <6vkeb7$rs6$1_at_hagen.cloud9.co.uk>#1/1
Date: 1998/10/09
Message-ID: <6vkeb7$rs6$1_at_hagen.cloud9.co.uk>#1/1
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 - 00:00:00 CEST