Re: - determine Operating system using pl/sql??

Howard J. Rogers wrote:
> Herman de Boer wrote:
>
>
> Nice idea. Shame it doesn't work in 8i or 9i or 10g.
>
> Did you perhaps mean port_STRING??
>
> And if you did, how do you account for this:
>
> SQL> select dbms_utility.port_string from dual;
>
> PORT_STRING
> ----------------------------------------------------------------
>
> IBMPC/WIN_NT-8.1.0
>
> SQL> select * from v$version;
>
> BANNER
> ----------------------------------------------------------------
> Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
> PL/SQL Release 9.2.0.1.0 - Production
> CORE 9.2.0.1.0 Production
> TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
> NLSRTL Version 9.2.0.1.0 - Production
>
> Now I realise that, regardless of version, the string is telling you
> that you're running on Windows NT (although this particular example
> happens to come from Windows 2000), which might be all that the original
> poster requires, but the wrong version number there is a bit of a worry,
> and makes me unconvinced that this is always going to be a reliable
> mechanism. Indeed, it reports "8.1.0" on 8.1.7, 9.2.0 and 10g, on both
> Windows and Linux.
>
> Regards
> HJR
 From dbsmutil.sql:

FUNCTION port_string RETURN VARCHAR2;

   PRAGMA RESTRICT_REFERENCES(port_string, WNDS, RNDS, WNPS, RNPS);

• Return a string that uniquely identifies the port (operating system)
• and the two task protocol version of Oracle. EG "VAX/VMX-7.1.0.0"
• "SVR4-be-8.1.0" (SVR4-b(ig)e(ndian)-8.1.0)
• maximum length is port specific.

So we're not talking about Oracle Version, but two task protokol version, what ever difference that makes.

Regards,
Holger Received on Wed Apr 28 2004 - 02:58:48 CDT