Re: The OS name of the server from PLSQL ?

From: Jurij Modic <jmodic_at_src.si>
Date: 1998/10/23
Message-ID: <3630fcc4.5824713@news.siol.net>#1/1

On Thu, 22 Oct 1998 11:48:02 +0200, Yves DEBIZET <yves.debizet_at_mc2.fr> wrote:

>How to retrieve the OS name of the server from PLSQL ?
>
>That would be useful in order to switch from WIN to UNIX pathnames
>replacing '\' with '/' and vice-versa.

I belive you could use a function PORT_STRING from a package SYS.DBMS_UTILITY. The comment in a dbmsutil.sql says that this function "return a string that uniquely identifies the version of Oracle and the port (operating system). EG "VAX/VMX-7.1.0.0"

Although I wouldn't bet the output of this function is 100% accurate regarding the RDBMS release and the OS (see below what it reports for my Personal Oracle *7.3.2* on *Win95* :-(( !!!), I belive it will distinguish betwen the WIN and UNIX reliably enough.

PORT_STRING

---

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

PORT_STRING

---

IBMPC/WIN_NT-7.0.0
>--
>Yves DEBIZET (mailto:yd_at_mc2.fr, tel: +33 0476 04 50 29, fax: +33 0476 04
>50 01)
>MC2 (http://www.mc2.fr)
>4 Chemin de Malacher, ZIRST 4401
>F38944 Meylan Cedex

Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Oct 23 1998 - 00:00:00 CDT