Hi All

when i am running this programme i am getting an
exception after sometime.how do i handle this
exception ?

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);
output utl_file.file_type;
begin
output := utl_file.fopen( '/db/oracle/test',
'view.txt', 'w' );
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||
';';
utl_file.put(output,query_txt);
utl_file.new_line(output);
utl_file.new_line(output);
end loop;
utl_file.fclose( output );
end;

declare
*
ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 29

regards
Hrishy

__________________________________________________
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