Re: The OS name of the server from PLSQL ?

From: yong <yong_at_shell.com>
Date: 1998/10/27
Message-ID: <36364628.44FE7DBF@shell.com>#1/1

"John P. Higgins" wrote:

> Try the v$session table. Look at the MACHINE column in a row where the TYPE
> = 'BACKGROUND'. This works on HP-UX. I don't have an NT to try it on.

This gives the name of the server machine, not the operating system. Oracle is stupid from ground up in that it doesn't allow us to easily run an operating system command from their proprietary language PLSQL. I don't know too many languages. But all I know except PLSQL have a command similar to system("dir"). Many newbies (e.g. me) wondered why SQL commands !dir or host dir won't work in PLSQL. I still don't understand. Oracle does.

Yong Received on Tue Oct 27 1998 - 00:00:00 CST