Hi All

I am executing the following pl/sql how do i overcome
the folowing error message.

declare
type my_curs_type is REF CURSOR;
curs my_curs_type;
--str varchar2(1000);
--t_name varchar2(50);
c_name varchar2(50);
--tab_name varchar2(2000);
cursor cur_tab_name is select distinct table_name as
tab_name from
user_tables where table_name like '%917';
query_txt varchar2(4000);
begin
for rr in cur_tab_name loop
OPEN curs FOR select column_name from
user_tab_columns
where table_name=rr.tab_name and column_name
not in ('T$REFCNTD','T$REFCNTU');
query_txt := 'create or replace view
'||rr.tab_name||'_vw as select ';
loop
fetch curs into c_name;
EXIT WHEN curs%NOTFOUND;
query_txt := query_txt||c_name||',';
end loop;
close curs;
query_txt := rtrim(query_txt,',');
query_txt := query_txt||' from '||rr.tab_name;
dbms_output.put_line(query_txt);
end loop;
end;
ERROR at line 1:
ORA-20000: ORU-10028: line length overflow, limit of
255 bytes per line
ORA-06512: at line 25




__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
Oracle LazyDBA home page