SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reading Environment Variable from pl/sql

564076Mar 10 2009 — edited Mar 11 2009

HI All,
I am using Oracle 10g R2 Database. I need to read the value of some of the environment variables in my PL/SQL block. How to achieve this? I have come across dbms_system.getenv(), but is it supported in Oracle 10g as I dont see any documentation and can any user use this feature?. I need to read the envrionment variables since I have to create a directory ( Create or Replace Directory ..) by concatenating the values of the envrionment variables set on the Oracle Database machine.

Please advise.

Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 8 2009

Added on Mar 10 2009

12 comments

15,137 views