FYI: v$session.machine may hold ASCII 0 characters

Hi everybody,

Just for your information: I spent quite a lot of time today to find that the column machine in v$session can hold ASCII 0 characters. You might only see them when you use something like

    select osuser, username, dump(machine)     from v$session;

In my case (Oracle 8.04, Sun Solaris), all Unix users have a "normal" varchar2 value specifying the machine name. The WinNT users however, connecting to the Sun Solaris database server through SQL*Net, showed this zero-character at the last position. This messed up things in my Windows pop-up window (which simply did not show the rows that were fetched after a row with such zero-character), while the same query gave me no problems at all in SQL*Plus...

I now use something like

    select osuser, username, rtrim(machine, chr(0))     from v$session;

but still wonder if this is normal behavior...

Arjan. Received on Tue Apr 13 1999 - 12:23:31 CDT