Re: DBMS_OUTPUT.put_line seems done nothing ?

yes you're right in this case.

Thierry Poels wrote:

> 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 - 09:01:36 CDT