wwv_flow_utilities.export_page_to_clob

set define off
set serveroutput on

select * from v$version;

declare
  c clob;
  amount binary_integer := 100;
  buffer varchar2(32767);
begin
  
  c := wwv_flow_utilities.export_page_to_clob(110,5);
  dbms_lob.read(c, amount, 1, buffer);
  dbms_output.put_line('1st run');
  dbms_output.put_line(buffer);

  dbms_output.put_line('------------');

  c := wwv_flow_utilities.export_page_to_clob(110,5);
  dbms_lob.read(c, amount, 1, buffer);
  dbms_output.put_line('2nd run');
  dbms_output.put_line(buffer);

  dbms_output.put_line('------------');

  c := wwv_flow_utilities.export_page_to_clob(110,5);
  dbms_lob.read(c, amount, 1, buffer);
  dbms_output.put_line('3rd run');
  dbms_output.put_line(buffer);

end;
/

exit

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE	11.2.0.2.0	Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production

1st run
Content-type: application/text
Content-length: 109859

set define off
set verify
off
set feedback of
------------
2nd run
set define off
set verify off
set feedback off
WHENEVER SQLERROR EXIT
SQL.SQLCODE ROLLBACK
begin wwv
------------
3rd run
set define off
set verify off
set feedback off
WHENEVER SQLERROR EXIT
SQL.SQLCODE ROLLBACK
begin wwv

PL/SQL procedure successfully completed.