Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sqlplus dbms_output

sqlplus dbms_output

From: <soalvajavab1_at_yahoo.com>
Date: 19 Sep 2006 09:06:40 -0700
Message-ID: <1158682000.357323.180510@i3g2000cwc.googlegroups.com>


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;

end; Received on Tue Sep 19 2006 - 11:06:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US