Read OS environment variables using DBMS_SYSTEM.GET_ENV()

March 27, 2009 by 5 Comments

Check out this article by Vikram Das about how to read OS environment variables using PL/SQL.

I did not know that!

Filed Under: Cool stuff, Oracle Tagged With:

Comments

  1. Tanel Poder says:
    March 27, 2009 at 12:39 pm

    Note that Oracle 9.2 doesn’t have this procedure, 10.2 has (and I didn’t test 10.1)

    Reply
  2. Maxim says:
    March 27, 2009 at 2:38 pm

    It depends, what the environment is referred to – in my quick test, it seems to return the actual environment for beq connections and the environment, oracle instance was started with – for Net 8 connections.

    Best regards

    Maxim

    Reply
  3. Tanel Poder says:
    March 27, 2009 at 2:41 pm

    Yes, because the BEQ connections are spawned by your user shell, but Net8 connections by the listener.

    For some troubleshooting purposes I’ve used such technique in past that I’ve created another “debug” listener which I started with LD_PRELOAD pointing to a custom library (which did some function call tracing) and only the users connecting through the debug listener would have the tracing enabled…

    Reply
  4. Chris Poole says:
    March 27, 2009 at 5:46 pm

    This API was introduced in 10.1, as I noted two years ago…!

    Reply
  5. Mark Brady says:
    June 22, 2010 at 10:47 am

    A search of Oracle documentation for 10.2 and 11.1 returns no results in the PL/SQL supplied packages reference, what gives?

    Reply

Speak Your Mind

*