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?
+59- Celebrity
- 3699 replies
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.