Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DBMS_OUTPUT.put_line seems done nothing ?
You're missing two lines.
set serveroutput on; /* Insert before your declare stmt.*/ dbms_output.enable; /* Insert after your begin.*/
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 - 06:07:18 CDT