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

Home -> Community -> Usenet -> c.d.o.misc -> DBMS_OUTPUT.put_line seems done nothing ?

DBMS_OUTPUT.put_line seems done nothing ?

From: Jack <zhangjun1975_at_263.net>
Date: 19 Oct 1999 08:55:19 GMT
Message-ID: <01bf1a0f$dbaad1e0$b20a0a0a@smile.newksy.com.cn>


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 - 03:55:19 CDT

Original text of this message

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