Skip to main content
  • EN

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?

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


Community Stats

30,168
Posts
114,528
Replies
37,826
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.