PL/SQL question dbms

From: robert <newsreply_at_#removethis#cookiesoftware.nl>
Date: Sun, 27 Oct 2002 14:26:44 +0100
Message-ID: <apgph1$n53$1@reader13.wxs.nl>

This code

CREATE OR REPLACE PROCEDURE GO IS
CURSOR C1 IS
select audsid,sid,serial#,username,terminal,osuser,PROGRAM,status,logon_time from v$session;
BEGIN
DBMS_OUTPUT.PUT_LINE(rpad(' ',80,'-'));

   DBMS_OUTPUT.PUT_LINE(rpad('SID',4,' ')||' '||RPAD(' '||'DB Account',15,'

')||' '||RPAD(' '||'OS Account',15,' ')||' '||RPAD(' '||'Client PC',15,'
')||' '||RPAD(' '||'Program',15,' ')||' '||RPAD(' '||'Status',15,' '));

DBMS_OUTPUT.PUT_LINE(rpad(' ',80,'-')); FOR REC IN C1
LOOP
DBMS_OUTPUT.PUT_LINE(REC.PROGRAM||REC.OSUSER); DBMS_OUTPUT.PUT_LINE(REC.OSUSER||REC.PROGRAM); END LOOP;
END GO;
/

gives me this output:

ORACLE.EXESYSTEM
SYSTEM
ORACLE.EXESYSTEM
SYSTEM
ORACLE.EXESYSTEM
SYSTEM
ORACLE.EXESYSTEM
SYSTEM
ORACLE.EXESYSTEM
SYSTEM
ORACLE.EXESYSTEM
.......
....

Why isn't the output on every second line SYSTEMORACLE.EXE ???

I tryed it all but can't seem to figure it out...

Thanks in advance,

Robert Received on Sun Oct 27 2002 - 07:26:44 CST

PL/SQL question dbms_output