Oracle Database Express Edition (XE)

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!

Accessing Local environment variable inside udf.

d94009fc-ee1c-47e4-81fd-ce8a29cd3b4fMay 16 2017 — edited May 17 2017

Hi guys ,

I was writing c++ udf for oracle data which was trying to get environment variable using get_env() function of c++.This function only return values for oracle specific environment variables like ORACLE_HOME,ORACLE_SID.If i give other variables , it returns null values.I tried these following things-

1.gave permissions to oracle user so that it can look into ~/.bashrc(in my case) and read env variables.

2.i made changes in oracle-env.sh which is placed at $ORACLE_HOME/bin.

3. I made changes in listener.ora .

4. I made changes in oraenv .

Still can't access env variables.I don't know whether it is possible or not to access local environment variables.Help me out please.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 14 2017

Added on May 16 2017

4 comments

603 views