Re: DBMS_OUTPUT.put_line seems done nothing ?

From: Thierry Poels <Thierry.Poels_at_vab.be>
Date: Tue, 19 Oct 1999 15:36:39 +0200
Message-ID: <7uhs6j$6kd$1@news1.skynet.be>

dbms_output.enable(1000000);

??? Why would anybody reserve this much to output only one line ???

regards,
Thierry Poels
Oracle DBA & HP-UX Sysadmin

Tom Verhagen <tverhage_at_aon.nl> wrote in message news:380C337C.BE3FEF7C_at_aon.nl...
> use: set serveroutput on before the pl/sql block
> and: dbms_output.enable(1000000); in the pl/sql block at the beginning
>
> Jack wrote:
>
> > Hi all:
> >
> > A friend of mine give me an PL/SQL scripts as followings:
> >
> > declare
> > start_time number;
> > end_time number;
> > object_count number;
> > begin
> > start_time := dbms_utility.get_time;
> > select count(*) into object_count from tab;
> > end_time := dbms_utility.get_time;
> > dbms_output.put_line('The count was completed in
> > '||(end_time-start_time)/100||' seconds.');
> > end;
> >
> > But when I run it, I can only see "PL/SQL procedure successfully
> > completed." on
> > the screen. Nothing more. I don't know why?
> >
> > Thanks in advance.
> >
> > Jack.
>
Received on Tue Oct 19 1999 - 08:36:39 CDT