Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> sqlplus dbms_output
Why I do not see the output of the following procedure in sqlplus??? As
you see I execute serveroutput on command at beginnig but still it does
not display the result, Please advise>
set serveroutput on
set serveroutput on size 200000
declare
begin
for tab in (select table_name from user_tables where table_name = '\"BMA_Chemical\"')
loop dbms_output.put_line(' create table
'||tab.table_name||'(');
for col in (select column_name,data_type,data_length from user_tab_columns where table_name = tab.table_name) loop dbms_output.put_line(col.column_Name||'
'||col.data_type||' ('||col.data_length || '),');
end loop; dbms_output.put_line('dummy date)'); end loop;
![]() |
![]() |