set long 1000000 pagesize 0 longchunksize 1000
column get_clob format a80
select dbms_advisor.get_task_report(:task_name, 'TEXT', 'TYPICAL')
from? dual;
spool off;
prompt
prompt End of Report
prompt Report written to &report_name.
set termout on;
clear columns sql;
ttitle off;
btitle off;
repfooter off;
undefine report_name