Re: System Variable in PL/SQL

Jeff Hansen (jhanse1_at_abacus.tis.tandy.com) wrote:
> I would like to write some PL/SQL scripts that could access some system type
> variables such as :
> system name / node name / machine name
> SID / instance
>

These type of variables you can get by using the dbmspipe package. Write a detached process which listens on a pipe. When you want to ask for one of these variables you put your request on the pipe and the detached process (in a 3rd GL) would send back the required result.

I don't think there is something like getenv() in PL/SQL

--
**************************************************************
*                          Saad Ahmad                        *
*                          McHugh Freeman & Associates, Inc. *
*                          Ph:  (414) 798-8606 Ext. 457      *
*                          Fax: (414) 798-8619               *
*                          E-Mail: sahmad_at_mfa.com            *
**************************************************************