Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DBMS_OUTPUT.put_line seems done nothing ?
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 - 04:01:48 CDT