Skip to main content
Question

Set environment variable for ORACLE_HOME at runtime

  • June 2, 2022
  • 1 reply
  • 148 views

killphil84
Participant
Forum|alt.badge.img

I'm working on a system which has Oracle Client 32Bit and 64Bit installed. The environment variable for ORACLE_HOME points to the 64Bit version. I need FME to use the 32Bit Version of the Oracle Client - just for this very FME process. Is it possible to set the environment variable temporarily at runtime (e.g. Phytin Startup Script)? How would this be done?

1 reply

redgeographics
Celebrity
Forum|alt.badge.img+49

You can use a SystemCaller to issue the Set command. Probably 3 times:

First to find out what the ORACLE_HOME parameter is

Then to change to what it should be

Then read/write your data (using FeatureReader and FeatureWriter transformers rather than regular readers and writers

And finally set it back to what it was.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings