Question

Set environment variable for ORACLE_HOME at runtime

  • 2 June 2022
  • 1 reply
  • 27 views
K

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
Rank
Userlevel 4
Badge +25

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

28,661
Posts
109,318
Replies
36,528
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.