Your CLOB scanning will go something like this
create or replace procedure my_get_clob
is
l_clob clob;
l_amt number default 4000;
l_off number default 1;
l_data varchar2(4000);
l_start_time varchar2(21);
l_end_time varchar2(21);
begin
select to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') into l_start_time from dual;
htp.prn(l_start_time);
htp.prn('<br>');
dbms_lob.createTemporary( l_clob, true );
dbms_lob.open( l_clob, dbms_lob.lob_readwrite );
l_amt := 100;
for i in 1 .. 30000
loop

--dbms_lob.writeAppend( l_clob, 32000, rpad('*',32000,'*') );
dbms_lob.writeAppend( l_clob, 100, rpad(lpad(to_char(i),8,'0'),100,'*') );
end loop;

begin
loop
dbms_lob.read( l_clob, l_amt, l_off, l_data );
htp.prn( l_data );
htp.prn( '<br>' );
l_off := l_off+l_amt;
l_amt := 100 ;
end loop;
dbms_lob.close( l_clob );
dbms_lob.freeTemporary( l_clob );
exception
when no_data_found then
select to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') into l_end_time from dual;
htp.prn('<br>');
htp.prn(l_end_time);
htp.prn('<br>');
NULL;
end;
end;
/
show errors
set serveroutput on size 1000000;
declare
begin
my_get_clob;
end;
/
You will need grants on OWA_UTIL packages , htp package etc.

---
HTH

GovindanK

On Wed, 30 Apr 2003 16:15:01
Joao Carlos wrote:
>Hello
>
>I trying to use sys.dbms_xmlgen.
>ex.
>select sys.dbms_xmlgen.getxml('select owner, table_name from dba_tables)
>from dual ;
>
>this select returns a CLOB with XML data.
>
>Anyone knows some package to show XML data from CLOB in a html tabular
>report?
>howto generate styles?
>Its necessary java on database?
>
>
>Thanks
>
>
>JC
>
>
>--------
>Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>


____________________________________________________________
Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
http://login.mail.lycos.com/r/referral?aid=27005
Oracle LazyDBA home page