-- generate a clob and save it to file declare l_clob clob; begin l_clob := ''; for l_rec in (select * from emp) loop l_clob := l_clob || '

' || l_rec.ename || '

'; end loop; l_clob := l_clob || ''; file_util_pkg.save_clob_to_file ('DEVTEST_TEMP_DIR', 'my_generated_web_page.html', l_clob); end;