Re: -Determine OS in pl/sql package ?

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 30 Apr 2004 19:21:47 -0700
Message-ID: <1083378103.457728@yasure>

Rob C wrote:

> select dbms_utility.port_string from dual;
>
> IBMPC/WIN_NT-8.1.0
>

Only one problem:

PORT_STRING

---

IBMPC/WIN_NT-8.1.0 which would be fine except:

SQL> select banner from v$version;

BANNER

---

Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for 32-bit Windows: Version 9.2.0.4.0 - Production NLSRTL Version 9.2.0.4.0 - Production

So I suspect the dbms_utility.port_string hasn't been updated since the last millenium.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Fri Apr 30 2004 - 21:21:47 CDT